I installed Hive ODBC Driver for HDP 2.3 on my windows machine. I am trying to connect to hive through ODBC(hadoop is installed on CENTOS and the cluster is kerberised).I encoutered following error. I followed the hortonworks document.I gave the server ip and port as 10000. hiveserver2 is running and working fine. Please find the screenshot odbc_error.png attached. Please suggest a solution.
When you say kerberized, which directory services are you using AD or Linux KDC? If you are using AD and your Windows in on same AD you should be able to connect.
To troubleshoot try using beeline in CentOS CLi to connect to hiveserver2 using jdbc and proper credentials.
I have the same problem.
HDp-2.3.6 and Hive ODBC driver v2.1.5,.
I get the below error.
FAILED! [Hortonworks][Hardy] (34) Error from server: connect() failed: errno = 10060.
I tried with know too but same error.
My cluster is kerberized and Windows machine from which I am trying to connect to Hive server used AD Kerberos.
AD and my local MIT Kerberos are trusted in one-way.
I am able to connect using old driver but problem is with the new driver.
Please help us with it.
I was able to connect from CLI using jdbc URL.
My problem solved.
Do as below when connecting via Knox
Hortonworks Hive ODBC driver DSN set up
Hive server type: hiveserver2
Authentication mechanism: user and password
Thrift transpot: HTTP
Select HTTP options:
HTTP path: gateway/<topology-name>/hive
Select SSL options:
Allow common name Host name mismatch
Allow Self signed server certificate