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>

0 COMMENTS

We’d like to hear from you!