Port Requirements | QueryGrid - Port Availability - 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
lifecycle
latest
Product Category
Analytical Ecosystem

Make sure that network ports are open between the QueryGrid-attached systems (data sources) and QueryGrid Manager by running curl -k https://qgm_host:9444/api from the node to check connectivity to QueryGrid Manager. Systems include the Teradata nodes, Hadoop master node, all Hadoop data nodes, Presto nodes, Oracle driver nodes, BigQuery driver nodes, and Generic JDBC driver nodes.

The following illustration and table describe the port numbers used between QueryGrid-attached systems and QueryGrid Manager in a fabric.



Port Description
22
  • One-way connection from the QueryGrid Manager to all QueryGrid-attached nodes; used if performing automatic installation of packages.
  • One-way connection from the QueryGrid Manager to another QueryGrid Manager; used during cluster creation when using the SSH method.
443
  • One-way connection to access Google BigQuery and Cloud Storage.
  • One-way connection to access the BigQuery API and OAuth API endpoints using a standard HTTPS connection.
1025/443 One-way connection from the target Teradata driver to the target Teradata system (JDBC connection).
1521 One-way connection from the target Oracle driver to the target Oracle system.
5000-5002 Two-way connections between all QueryGrid-attached nodes; other available ports can be used, but ports 5000-5002 are recommended. When upgrading, two ports per fabric are required.
8090 One-way connection from the target Presto driver to the target Presto coordinator.
8443 One-way connection from the target Hive driver to the Apache Knox Gateway if Apache Knox Gateway is enabled on Hadoop nodes.
9443
  • One-way HTTPS connection from Viewpoint or a browser to QueryGrid Manager.
  • One-way connection from QueryGrid Manager to another QueryGrid Manager; used during cluster creation when using the join token method.
9444 One-way HTTPS connection from QueryGrid-attached nodes to QueryGrid Manager.
9445 Two-way HTTPS connection between clustered QueryGrid Managers in a fabric.
10000 One-way connection between the target Hive driver to target Hiveserver2.
10016 One-way connection from the target Spark SQL driver to the target Spark Thrift Server.
* For Generic JDBC connector, the port required depends on the data source. Refer to your data source user guide for port requirements.