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
Host Name indicates the name of the machine that hosts the Hive master server, and
Port indicates the port number on which the Hive master server listens.
The following sample code shows the parameters for Hive:
<HiveConfiguration>
<JDBCUrl>jdbc:hive2://myhost:10000/default</JDBCUrl>
<KeyTabFile>/etc/security/keytabs/hive.keytab</KeyTabFile>
<PrincipalName>hive/_Host@realm.com</PrincipalName>
</HiveConfiguration>
