2.10 - Adding a Connector - 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
  1. Under Fabric Configuration, select Fabrics and click a fabric to which you want to add a connector.
  2. Click the Connectors tab.
  3. Click the "" next to Connectors.
  4. Type a name, up to 256 characters.
  5. Type a description, up to 1,000 characters.
  6. In the System list, select a system you want to add this connector to.
  7. Next to Allowed OS users, click "" to add the allowed OS user that this software runs as. This user is typically the same user under which the database runs:
    • For a Teradata Database connector it is the teradata user.
    • For a Presto connector it is the presto user.
    • For a Hive connector, you must add the user executing the query (which may be hive), yarn user, and Kerberos principal or other authorized user.
    • For a Spark SQL connector, you must add the user executing the query (which may be hive), yarn user, and Kerberos principal or other authorized user.
  8. Do one of the following:
    Option Description
    Select an existing connector software version
    1. From the Software Name list, select an existing software version.

      The list contains the Teradata, Presto, or Hive connector software packages you uploaded earlier.

    Upload a new connector software version
    1. Next to the Software Name list, click "".
    2. Browse to the file and click Upload.
    3. From the Software name list, select the uploaded version.
    4. Click Save.
  9. In the Server box, enter the hostname of the server.
  10. Click "" next to Connector Software.
  11. In Select Connector Properties, do one or more of the following:
    Option Description
    Customize
    1. Select the check box to customize the values for a connector property.

      When the check box is cleared, it designates that QueryGrid should use the default values for a property.

    You can further customize initiator and target connector properties at the link level in the Links tab.
    Overridable
    1. [Optional] Select the check box to designate that the normal configured values for the connector property can be overridden when a user executes queries during individual processing sessions.
    Once you designate a property as overridable at the connector level, it stays in effect even if you do not designate it as overridable at the link level in the Links tab.

    In order to disable the setting for an initiator or target connector, you must clear the check box at both the link level and connector level.

    For these reasons, it might be preferable to designate a property as overridable only at link level in the Links tab, depending on the requirements specific to the link.

  12. Click OK to save the configuration. Under Connector Software, all properties you set to customize appear.
  13. Modify each setting to govern how the connector operates. For complete descriptions of all properties for each connector type, see:
  14. Under Driver Nodes, do one of the following to designate where driver nodes are available:
    Option Description
    Make available on all nodes
    1. Click Make available on all nodes.
    Make available on selected nodes only
    1. Click Make available on selected nodes only.
    2. Click Select Nodes.
    3. In the Available nodes filter box, type some text and one or more wildcards to get a subset of the available nodes to display in the Available nodes list.
    4. Click "" to move the nodes you want from the Available nodes list to the Selected nodes list.
    5. Click Save.
  15. [Optional] From the Associated Viewpoint system list, select a Viewpoint system to associate with this connector. This association is used to link Viewpoint monitored systems to QueryGrid queries in portlets, such as Query Monitor.
  16. Click Save.