The following limitations affect use of Presto connectors with Teradata QueryGrid:
- Use of Presto is limited to queries that can be performed in memory, so some queries may not be able to execute in Presto that would execute in Hive.
-
Transaction semantics between systems is not supported.
After data has been exported and committed to a remote system, any subsequent errors or aborts on the local system do not roll back the remote request.
- Presto does not support roles and access control.
- Teradata QueryGrid does not support TimeWithTimeZone and TimestampWithTimeZone data types with Presto connectors.
- When using the Explain command with a Presto initiator connector, remote query and execution plan data is not returned.
- The default for Timestamp precision is three (3); Teradata QueryGrid truncates data with more than three decimal places.
- When using Predicate pushdowns, Array, Time, TimeWithTimeZone, Timestamp, and TimestampWithTimeZone data types are not pushed down.