Complete these steps to verify a Presto-to-TargetConnector link (where TargetConnector is any type of target connector). For example, for a Presto-to-Teradata link:
- Log on as the Presto user to the Hadoop master node on which the Presto connector is installed.
-
Confirm setup of the Presto-to-TargetConnector link properties file by invoking the Presto CLI, then running SHOW CATALOGS. For example, for a Presto-to-Teradata connector link:
tdh234m1:~ # presto-cli --server localhost:8090 presto> use hive.testuser; presto:testuser> show catalogs;
The following output indicates that the Presto-to-Teradata link properties file tdh234m1sdld0461_active is set up and recognized as a catalog by Presto:Catalog ------------------------- hive qginitiator qgremote system tdh234m1sdld0461_active tpch
-
Retrieve all databases on a Teradata system by running SHOW SCHEMAS FROM <catalog_name>. For example:
presto:testuser> show schemas from tdh234m1sdld0461_active;
The following output indicates retrieval of all databases including system databases that reside on the target Teradata system:Schema ------------------------- PUBLIC SQLJ SYSBAR … testuser …
-
Retrieve all tables in a Teradata database by running SHOW TABLES FROM <catalog_name>.<schema_name>. For example:
presto:testuser> show tables from tdh234m1sdld0461_active.testuser;
The following output indicates retrieval of all tables in the testuser database that reside on the target Teradata system:Schema ------------------------- testtable1 testtable2 …