If you use Kerberos authentication, provide the Kerberos principal for authentication when you configure the Apache Hive catalog source in Metadata Command Center. Also, configure the Secure Agent machine to work with the Kerberos Key Distribution Center (KDC).
Verify that you have the URL to connect to Apache Hive.
1Open the hosts file located on the Secure Agent machine.
On a Windows machine, the hosts file is available in the following path: C:\Windows\System32\drivers\etc\hosts
On a Linux machine, the hosts file is available in the following path: /etc/hosts
2Add details of the Kerberos server to the hosts file in the following format: <IP address> <Host name>
3Add the KDC server IP address to the file in the following format: <KDC server IP address> <Fully qualified name of the KDC server> <Alias name>
4Save and close the file.
5Verify that the Kerberos configuration file is available on the Secure Agent machine.
On a Windows machine, the krb5.ini configuration file is available in the following path: C:\Windows
On a Linux machine, the krb5.conf configuration file is available in the following path: /etc
6 Copy hive.keytab, core-site.xml, and hive-site.xml files from the Hadoop cluster node to a directory on the Secure Agent machine.
7Download the Keytab file from the Kerberos administrator and copy it to a directory on the Secure Agent machine.