2.10 - Validating a Presto-to-TargetConnector Link - 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
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:
  1. Log on as the Presto user to the Hadoop master node on which the Presto connector is installed.
  2. 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
  3. 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
    …
  4. 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
    …