All Apps and Add-ons

Splunk DB Connect with HIVE integration

kc64645
Explorer

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.

Labels (2)
0 Karma
Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!