2.06 - Setting Up the Presto Initiator Catalog Properties File - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.06
Published
September 2018
Language
English (United States)
Last Update
2018-11-26
dita:mapPath
blo1527621308305.ditamap
dita:ditavalPath
ft:empty
You define Catalog properties for the Presto connector in a properties file that is manually created and edited. This is different than the Teradata connector properties, which are defined using the QueryGrid portlet.

The Presto catalog properties file references a data source and maintains the set of properties associated with that data source connector. You can have one or more catalogs per connector. The Presto connector can have multiple initiator catalogs, one for each link and version pair. The catalog properties file is analogous to the CREATE FOREIGN SERVER statement for the Teradata connector.

External NVP can be defined for links and for connectors. For Presto connectors, the External NVP are stored in the link properties file. After manually editing the file, you must restart the Presto server for the new configuration to take effect.

Do the following to configure the Presto catalog properties file:

  1. Log on as an Administrator to the master node of the Hadoop cluster where Presto is installed.
  2. Create and edit an initiator catalog properties file: ~/.prestoadmin/catalog/<name.properties>. For example, create and edit a file named tdh234m1sdld0461_active.properties. Add the following content to the file:
    connector.name=qginitiator
    qginitiator.linkName=tdh234m1sdld0461
    qginitiator.version=active
  3. Run presto-admin catalog add <name> to deploy the properties file on all nodes. For example:
    presto-admin catalog add tdh234m1sdld0461_active
  4. Restart the Presto cluster. Run:
    presto-admin server restart
  5. From Presto CLI use the SHOW CATALOGS command to verify the newly created properties file exists. Run:
    tdh234m1:~ # presto-cli --server localhost:8090
    presto:testuser> show catalogs;
    Result:
    Catalog
    -------------------------
     hive
     qginitiator
     qgremote
     system
     tdh234m1sdld0461_active
     tpch