Created 02-27-2023 12:55 AM
Hello,
I am unable to access Hive using Beeline connection string in the edge node. The JDBC String that I am using is as follows:
beeline -u "jdbc:hive2://Example.com:10000/default;principal=hive/Example.com@EXAMPLE.COM"
Error:
Unknown HS2 problem when communicating with Thrift server.
Error:jdbc:hive2://Example.com:10000/default;principal=hive/Example.com@EXAMPLE.COM: Invalid status 21 (state=08S01,code=0)
Help is required to fix this issue.
Thank you.
Created 02-27-2023 03:33 AM
I see that you are using CDP 7.1.7. Follow below steps if youare using autoTLS
1. Check TrustStore Password:
======
# cat /etc/hive/conf/ssl-client.xml | grep -i -A1 "ssl.client.truststore.password"
<name>ssl.client.truststore.password</name>
<value>truststore_password</value>
======
2. Below should be used for Kerberos + SSL
beeline -u "jdbc:hive2://xxxxxx10000/default;principal=hive/xxxxx@CREAL;ssl=true;sslTrustStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-global_truststore.jks;trustStorePassword=trsutpwd"
Created 02-27-2023 01:15 AM
1. are you using SSL ?
2. Provide
beeline -u "jdbc:hive2://Example.com:10000/default;principal=hive/Example.com@EXAMPLE.COM" --berbose=true
3. Hiveserver2 logs
Created 02-27-2023 03:24 AM
1. Yes Iam using ssl
2. In below image have provided the output from the connection string
3. Have provided the SS for the log file in the below image.
Created 02-27-2023 03:33 AM
I see that you are using CDP 7.1.7. Follow below steps if youare using autoTLS
1. Check TrustStore Password:
======
# cat /etc/hive/conf/ssl-client.xml | grep -i -A1 "ssl.client.truststore.password"
<name>ssl.client.truststore.password</name>
<value>truststore_password</value>
======
2. Below should be used for Kerberos + SSL
beeline -u "jdbc:hive2://xxxxxx10000/default;principal=hive/xxxxx@CREAL;ssl=true;sslTrustStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-global_truststore.jks;trustStorePassword=trsutpwd"
Created 03-02-2023 09:46 PM
@Nur, Have the replies 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.
Regards,
Vidya Sargur,