Hi,
I am trying to setup HIVE connection using Splunk DB connect and stuck on Kereberos authentication. I have setup db_connection_types.conf and added cloudera drivers for HIVE DB. While setting up connection I am using below jdbc URL (as per clodera documentation) and getting Kerberos authentication error.
jdbc:hive2://<host>:10000/<db_name>;principal=hive/<my_kdc_principal_name>;AuthMech=1; KrbRealm=<kdc realm> ;KrbHostFQDN=<kdc host fqdn>; KrbServiceName=hive;KrbAuthType=2;useSSL=1
ERROR:
[Cloudera][HiveJDBCDriver](500168) Error creating login context using ticket cache: Unable to obtain Principal Name for authentication .
If I use below jdbc URL (as per other answers from Splunk Community), I am getting different KDC authentication error
jdbc:hive2://<host>:10000/<db_name>;principal=hive/<principal_name>;useSSL=1
ERROR:
[Cloudera][HiveJDBCDriver](500164) Error initialized or created transport for authentication: Invalid status 21.
Kindly help! Thank you.
