Configure Automatic Deployment for Hortonworks HDP | Teradata QueryGrid - Automatically Deploy QueryGrid on Hortonworks HDP - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Teradata QueryGrid
Release Number
July 2022
English (United States)
Last Update
Product Category
Analytical Ecosystem

This procedure creates a custom service named Teradata QueryGrid that helps with installation of QueryGrid software on Hadoop nodes. This service is similar to other services, such as HDFS and HBase. For compatibility information on QueryGrid components, see the Teradata QueryGrid Compatibility Matrix.

The Teradata QueryGrid service is packaged as a tar file named TDQG_DEPLOYMENT-version.tar.gz that is part of the node package tdqg-node.tar.gz.

This procedure assumes the following prerequisites:
  • You have required privileges to copy scripts to the Ambari server.
  • You have required privileges to restart the Ambari Server.
  • The cURL tool is installed on all nodes where you intend to install QueryGrid.
  1. Add a system and download the tdqg-node.json token file that was generated by QueryGrid Manager to the Teradata QueryGrid service.
    For information about downloading tdqg-node.json, see Adding Nodes Manually.
  2. Install the Teradata QueryGrid service on Ambari:
    1. Download the node package, then select the node component from the software package to the Ambari server (typically the HDP master).
      For more information, see Downloading Required Packages.
    2. Unzip the package:
      tar -xvzf tdqg-node-version.tar.gz
    3. In qgdeployment/ambari, locate TDQG_DEPLOYMENT.tar.gz.
    4. Unzip the TDQG_DEPLOYMENT package:
      tar -xvzf TDQG_DEPLOYMENT.tar.gz
    5. Copy the folder TDQG_DEPLOYMENT to the stacks on the Ambari server.
      The default path on the server is:

      cp -r /path_to_TDQG_DEPLOYMENT_folder /var/lib/ambari-server/resources/stacks/HDP/hdp-version/services

    6. Change access privileges:
      chmod -R +x /var/lib/ambari-server/resources/stacks/HDP/hdp-version/services/TDQG_DEPLOYMENT/*
    7. Restart the Ambari server:
      ambari-server restart

      After the Ambari server is restarted, QueryGrid is available as a service named Teradata QueryGrid.

    8. From the Ambari Web UI, select Add Service, then add the Teradata QueryGrid service to the master and data nodes.
    9. In the input parameter text, provide the complete text of the token file tdqg-node.json.
      The token file tdqg-node.json is in advanced qgconfig.
  3. Do one of the following:
    Option Action
    Install QueryGrid on existing nodes
    1. From the Ambari Web UI, select Hosts.
    2. Select any node on which you want to install the Teradata QueryGrid service.
    3. Select "", then from the list of available services, select Teradata QueryGrid.

      Teradata QueryGrid appears in the list of installed services.

    Install QueryGrid on a new node
    1. From the Ambari Web UI, select Hosts.
    2. Select Actions > "" > Add New Hosts.

      For more information, see

    3. In the Assign Slaves and Clients list, select QueryGrid.