[CDH] Finding the FQDNs and Verifying the Port Numbers Used for the Hive Metastore Thrift Service - Presto on Teradata Appliance for Hadoop

Presto on Teradata Appliance for Hadoop 6 Installation, Configuration, and Upgrade Guide

Product
Presto on Teradata Appliance for Hadoop
Release Number
157t
Published
February 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
jpl1484678832656.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
jpl1484678832656
Product Category
Open Source
The following procedure explains how to find the FQDNs and verify the port numbers used for the Hive metastore Thrift service (hive.metastore.uris). The FQDNs and port numbers are used when adding the Hive connector.
Replace the FQDNs in the examples with the FQDNs for your Hadoop nodes.
Teradata Appliance for Hadoop 6 is usually configured as a high availability (HA) system. In an HA system, the Hive metastore Thrift service is set up on two Master Nodes. You will need the FQDNs and port numbers of both nodes when you add the Hive connector. Each FQDN must be of a Hadoop node in the cluster.
  1. Go to http://cm:7180, where cm is the FQDN of the node where Cloudera Manager is installed. For example, http://xyz721m1.customer.com:7180.
  2. Log in to Cloudera Manager.
  3. On the Home page, click Hive.
  4. In the Status Summary section, click Hive Metastore Server.
  5. On the results page, do the following.
    1. Find the rows for the Hive Metastore Server.
    2. Record the FQDNs displayed in the Host column. For example, FQDNs similar to xyz721m1.customer.com and xyz721m2.customer.com are the FQDNs to use in the hive.properties file.
  6. On the Hive page, click Configuration.
  7. In the Configuration section, do the following.
    1. In the search box, type: hive metastore server port
    2. Verify that the port number is 9083.
      The default port number 9083 is used for the examples in the procedure steps. If you are not using the default port number, record the displayed port number.
  8. From the admin list, select Logout.