SQL Syntax | Presto Connector | QueryGrid - SQL Syntax for the Presto Initiator Connector - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem
QueryGrid supports the following SQL statements from a Presto connector node:
  • SELECT
  • INSERT
  • SHOW SCHEMAS, SHOW TABLES, SHOW COLUMNS, SHOW CATALOGS
  • DESCRIBE

SQL syntax used with the Presto connector differs from Teradata SQL syntax. One notable change is that you must qualify a table with its catalog, for example: QGNG.salesdb.sales. QGNG is the catalog name, salesdb is the schema name, and sales is the table name.

The names of catalogs, schema, tables, and columns are not modified by QueryGrid unless either the local system or the remote system is unable to support the name in its native format. This includes uppercase, lowercase, and mixed case, as well as multi-byte names in language character sets.