PrestoDB translator (prestodb)
Also see common JDBC translators information.
The PrestoDB translator, known by the type name prestodb, exposes querying functionality to Presto data sources. In data integration respect, PrestoDB has very similar capabilities of Teiid, however it goes beyond in terms of distributed query execution with multiple worker nodes. Teiid’s execution model is limited to single execution node and focuses more on pushing the query down to sources. Teiid provides more complete query support and many enterprise features.
The PrestoDB translator supports only SELECT statements with a restrictive set of capabilities.
Because Presto exposes a relational model, Teiid can use it as it does other RDBMS sources, such as Oracle, DB2, and so forth. For information about configuring Presto, see the Presto documentation.
|
Tip
|
In SQL JOIN operations, Presto does not support multiple ORDER BY columns well.
If errors occur during JOIN operations that involve more than one ORDER BY column,
set the translator property supportsOrderBy to disable the use of the ORDER BY clause.
|
|
Note
|
Some versions of Presto generate errors when you include null values in subqueries. |
|
Tip
|
PrestoDB does not support transactions. To overcome issues caused by this limitation, define the datasource as non-transactional. |
|
Note
|
By default, every catalog in Presto has an If you want to configure multiple Presto catalogs, set one of the following import options to filter the schemas and tables in the source:
|