SHOW | Presto Connector | QueryGrid - SHOW Syntax for the Presto 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
lifecycle
latest
Product Category
Analytical Ecosystem
The Presto SHOW statement provides the details of schemas/databases, tables, and table columns on local or remote systems. The SHOW CATALOGS statement lists the contents of the Presto catalog. The following statements are available:
  • SHOW SCHEMAS FROM <catalog_name>;
  • SHOW TABLES FROM <catalog_name>.<schemaname>;
  • SHOW COLUMNS FROM <catalog_name>.<schemaname>.<tablename>;
  • SHOW CATALOGS;
  • DESCRIBE <catalog_name>.<schema_name>.<tablename>;

The Presto DESCRIBE statement is an alias for the Presto SHOW COLUMNS statement and returns the same information.

The Presto SHOW statement is equivalent to the HELP FOREIGN statement used when Teradata is the initiator. For more information, see Examples of Using HELP FOREIGN.

Example: Presto to Teradata SHOW SCHEMAS

The example fetches the schema (databases) from the remote Teradata system. QD_TD1 is the catalog used to reference the Presto-to-Teradata link.

trino:default> SHOW SCHEMAS FROM QG_TD1;

Example: Presto to Teradata SHOW TABLES

The example fetches the list of tables from the specified database (<schemaname>) on the remote Teradata system.

trino:default> SHOW TABLES FROM QG_TD1.<schemaname>;

Example: Presto to Teradata SHOW COLUMNS

The example fetches the column information from the specified table (<schemaname>.<tablename>) on the remote Teradata system.

trino:default> SHOW COLUMNS FROM QG_TD1.<schemaname>.<tablename>;
The Presto DESCRIBE <catalog_name>.<schema_name>.<tablename> statement can be used instead of SHOW COLUMNS.

Example: Presto SHOW CATALOGS

The example lists the registered catalogs. It does not invoke a QueryGrid query.

trino:default> SHOW CATALOGS;

Result:

   Catalog
----------------
 hive
 qginitiator
 qgremote
 system
 QG_TD1
 tpch
The Presto-to-Teradata catalog called QG_TD1 is listed as well as the rest of the registered catalogs.