Windows - Hive connection issue through ODBC using Hive ODBC Driver for HDP 2.3

[#1]

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.

[#2]

@Vandana K R

You have to check the connection string and version of ODBC. Please provide the screenshot of your connection if possible

[#3]

http://hortonworks.com/hdp/addons/

http://hortonworks.com/wp-content/uploads/2015/10/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf

Page 50 and 51

[#4]

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.

[#5]

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.

[#6]

I was able to connect from CLI using jdbc URL.

!connect jdbc:hive2://<hivesrever>:10001/default;principal=hive/hiveserver@HADOOP.COM;transportMode=http;httpPath=cliservice

[#7]

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:

Enable SSL

Allow common name Host name mismatch

Allow Self signed server certificate

Now test