Table of Contents

Search

  1. Preface
  2. Installing Informatica MDM - Relate 360
  3. Configuring Relate 360
  4. Configuring Security
  5. Setting Up the Environment to Process Streaming Data
  6. Configuring Distributed Search
  7. Packaging and Deploying the RESTful Web Services
  8. Troubleshooting

Installation and Configuration Guide

Installation and Configuration Guide

Configuring the Hive Parameters

Configuring the Hive Parameters

You can configure parameters related to Hive, such as the JDBC driver for Hive, Service Principal Name (SPN) of the Hive master server, and the keytab file.
To configure the Hive parameters, add the following parameters to the HiveConfiguration section in the configuration file:
KeyTabFile
Optional. Absolute path and file name of the keytab file. A keytab file contains a list of keys that are analogous to user passwords. Applicable if you use Kerberos for authentication.
If you use the KeyTabFile parameter, ensure that the name of the file and the absolute path to the file are the same for all the nodes in a distributed Hadoop cluster.
PrincipalName
Required if you use Kerberos for authentication. Service Principal Name (SPN) of the Hive master server. For example, hive/_Host@realm.com.
You can get the SPN of the Hive master server from the hive.metastore.kerberos.principal property in the following file: ${HIVE_HOME}/conf/hive-site.xml
JDBCUrl
JDBC connection URL to access metadata from Hive.
Use the following format for the JDBC connection URL:
jdbc:hive2://<Host Name>:<Port>/default;<Additional Parameter 1>;<Additional Parameter 2>,...<Additional Parameter N>
The URL format uses the following parameters:
  • Host Name. Name of the machine that hosts the Hive master server.
  • Port. Port number on which the Hive master server listens.
  • Additional Parameter 1,2,...N. Additional parameters that are specific to your environment. For example, in an encrypted environment, use the sasl.qop parameter to specify the type of authentication you use. For example, sasl.qop=auth-conf indicates that the environment uses authentication with confidentiality protection. For more information about the sasl.qop parameter, see the documentation of your Hadoop distribution.
The following sample code shows the Hive parameters for Cloudera CDH:
<HiveConfiguration>
   <JDBCUrl>jdbc:hive2://1.254.254.254:10000/default;ssl=true;sslTrustStore=/etc/cloudera-scm-agent/custom.truststore;trustStorePassword=hadoop</JDBCUrl>
   <KeyTabFile>/run/cloudera-scm-agent/process/232-hive-HIVESERVER2/hive.keytab</KeyTabFile>
   <PrincipalName>hive/host@principal</PrincipalName>
</HiveConfiguration>
The following sample code shows the Hive parameters for Hortonworks HDP:
<HiveConfiguration>
   <JDBCUrl>jdbc:hive2://1.253.253.253:10001/default;transportMode=http;httpPath=cliservice;ssl=true;sslTrustStore=/etc/hive/conf/hivetrust.jks;trustStorePassword=hadoop</JDBCUrl>
   <KeyTabFile>/run/hdp-scm-agent/process/232-hive-HIVESERVER2/hive.keytab</KeyTabFile>
   <PrincipalName>hive/host@principal</PrincipalName>
</HiveConfiguration>


Updated June 27, 2019


Explore Informatica Network