We have 4 node HDP 2.3 cluster kerberized with Ad. Another client node(edge node) has been added into the cluster through ambari and hive client is installed.
But we saw that hive.service.keytab is not generated automatically, while it is available in other hive client. For this reason hive client unable to connect hive metastore using jdbc driver.
Can someone help?
Hello @khireswar Kalita . You do not need a Hive service keytab on the client node to make the JDBC connection to Hiveserver2. You do need to have a valid Kerberos ticket to perform the connection though. From the Linux command line you will execute the following command with your user ID: (please avoid doing this as hive or another service account)
You will then be prompted for your domain password. Once you enter the password you will be granted a ticket, which you can verify with the "klist" command. You would then be able to use the beeline client for a JDBC connection like so:
beeline -u "jdbc:hive2://hive2_host:10000/default;principal=hive/hive2_host@YOUR-REALM.COM"
Thanks for the reply.
In my case I could connect from beeline and hive cli without any issue. From some reason our developer getting issue while connecting from application. May be something missing in the code.