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.

<HiveConfiguration>
   <JDBCUrl>jdbc:hive2://myhost:10000/default</JDBCUrl>
   <KeyTabFile>/etc/security/keytabs/hive.keytab</KeyTabFile>
   <PrincipalName>hive/_Host@realm.com</PrincipalName>
</HiveConfiguration>