Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
VamsiBhagavathula1

Connect to Hive using cloudera odbc

Hello All,

On the Qlik sense machine, i have installed cloudera odbc hive driver and post installation i have been trying to connect to hive but its failing with an error.

 

 

FAILED!

[Cloudera][ThriftExtension] (2) Error occured during authentication.

 

 

Does anyone tried this approach and established a connect using odbc. please let me know how did you resolve it

Labels (1)
2 Replies
Jack_Guo
Support
Support

Hi @VamsiBhagavathula1 , have you checked the Qlik ODBC connector log and see you can find anything related to the error?

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/ODBC-l...

VamsiBhagavathula1
Author

@Jack_Guo  the problem is , connection is failing directly with the DSN created on top of cloudera hive odbc driver. The firewall is open to the hive host for port 10000. so how should we even verify this at DSN level ? The authentication is SASL via kerberos with a truststore.pem file.