Created on 05-09-2024 12:48 PM - edited 05-09-2024 12:49 PM
I am getting the below error while connecting to hive using jdbc url
Caused by: com.cloudera.hiveserver2.support.exceptions.GeneralException: [Cloudera][HiveJDBCDriver](500171) Error occurred Connecting to ZooKeeper: At: <my_host>:2181/hiveserver2
With Error Message: KeeperErrorCode = AuthFailed for /hiveserver2.
JDBC URL:jdbc:hive2://zk=<my_host>:2181/hiveserver2,<my_host>:2181/hiveserver2;SSL=1;SSLTrustStore=/trustore_path/cm-auto-global_truststore.jks;SSLTrustStorePwd=My_pwd;AuthMech=1;KrbRealm=MYREAL.ORG.COM;KrbHostFQDN=_HOST;KrbServiceName=hive;LogPath=/tmp/log
Created 05-24-2024 04:04 AM
Was a Kerberos issue this is resolved
Created 05-09-2024 03:58 PM
@hadoopranger Welcome to the Cloudera Community!
To help you get the best possible solution, I have tagged our Hive experts @cravani @james_jones who may be able to assist you further.
Please keep us updated on your post, and we hope you find a satisfactory solution to your query.
Regards,
Diana Torres,Created on 05-15-2024 02:46 AM - edited 05-15-2024 02:47 AM
1. Verify if the JDBC connection string is valid and correct.
2. Try to use the latest JDBC driver version that is available.
3. Check the HS2 servers that you are connecting are accepting the connections and in good health.
4. Check if beeline is working or not.
5. If all correct enable the JDBC driver trace level logging and get the more details on the error.
Regards,
Chethan YM
Created 05-23-2024 01:26 PM
@hadoopranger Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks.
Regards,
Diana Torres,Created 05-24-2024 03:02 AM
@hadoopranger Make sure that [1] Hive namespace "hiveserver2" is correct, [2] You have a valid kerberos ticket in the client machine.
Created 05-24-2024 04:04 AM
Was a Kerberos issue this is resolved