Configure Automatic Deployment for Cloudera CDH | QueryGrid - Automatically Deploy QueryGrid on Cloudera CDH/CDP - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem

This procedure creates a Cloudera Manager Extension, Custom Service Descriptor (CSD), that helps with installation of QueryGrid software on Cloudera Manager. This service is similar to other services, such as HDFS and HBase. For compatibility information on QueryGrid components, see the QueryGrid Compatibility Matrix.

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

This procedure assumes the following prerequisites:
  • You have required privileges to copy the jar file to Cloudera Manager (CM) server.
  • You have required privileges to restart the CM 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 QueryGrid service.
    For information about downloading tdqg-node.json, see Adding Nodes Manually.
  2. Install the QueryGrid service on Cloudera Manager
    1. Download the node package.
      For more information, see Downloading Required Packages.
    2. Unzip the package:
      tar -xvzf tdqg-node-version.tar.gz

      The CSD jar is available in the path qgdeployment/cloudera named TDQG_DEPLOYMENT.jar.

    3. Copy the jar file to the CSD repository on the CM Server.
      The default path on the server is: /opt/cloudera/csd
    4. Change the CSD files ownership and permissions:
      chown cloudera-scm:cloudera-scm /opt/cloudera/csd/TDQG_DEPLOYMENT.jar

      chmod 644 /opt/cloudera/csd/TDQG_DEPLOYMENT.jar

    5. Restart CM service cloudera-scm-server restart.
      After the CM server is restarted, QueryGrid is available as a service named QueryGrid.
    6. From the CM Web UI, select Add Service, then add the QueryGrid service.
    7. 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 an existing node in the cluster
    1. In CM, go to the service QueryGrid.
    2. Select Add Role Instances.
    3. Select the node where the service is to be installed, then select Continue.
    4. If the JSON configuration is invalid or has expired, change the input parameter Full text of tdqg-node.json, then select Continue.

      The service is added to the node.

    5. Select the new node, then select Actions for Selected > Start > Continue.
    Install QueryGrid on a new node

    While adding a new node with CM using Add Hosts wizard, select the service QueryGrid to install QueryGrid. This option is available when you select the host template.

    1. Create a host template with the QueryGrid service.

      For more information, see https://docs.cloudera.com/documentation/enterprise/latest/topics/cm_mc_host_templates.html#cmug_topic_7_7_1

    2. Select Hosts > Add Hosts, then select the host template.

      For more information, see https://docs.cloudera.com/documentation/enterprise/latest/topics/cm_mc_adding_hosts.html#cmug_topic_7_5_1__title_215