2.10 - SQL Syntax for the Presto Connector - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K

Teradata 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 Teradata 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.