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.