2.06 - Presto Connector Limitations - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.06
Published
September 2018
Language
English (United States)
Last Update
2018-11-26
dita:mapPath
blo1527621308305.ditamap
dita:ditavalPath
ft:empty
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.