HOW TO INSTALL AND CONFIGURE THE HORTONWORKS ODBC DRIVER ON WINDOWS 7

[#1]

Hi @Rahul Pathak

I was trying to configure my HortonWorks ODBC Driver and i am getting below error.

am i missing anything in the set up ? btw i am not getting what is Delagation UserID here.

FYI, I logged in as root user and password:Training123@Ravi and output of my ifconfig is

and I am refering the below link for configuring ODBC Driver and i am getting different set up window than what is available in link

http://hortonworks.com/hadoop-tutorial/how-to-install-and-configure-the-hortonworks-odbc-driver-on-w...

[#2]

/etc/hive/conf/

@Ravikumar Kumashi

[#3]

@Rajkumar Singh

[#4]

If the hive.server2.authentication and hive.server2.enable.doAs property are set as below

what should be the ODBC driver set up, I mean Host, port , database, authentication mehcanism, Delegation UID values.

FYI i logged in to sandbox using root as user and output of ifconfig is as below

[#5]

@Rajkumar Singh Binary and HTTP

[#6]

@Rajkumar Singh I tried with Binary and HTTP getting the error, please see below

I am thinking am i not giving the host, port, database and Delegation UID correct ?

Do i need to enable the sasl property in hive-site.xml

[#7]

what are the other options available in Thrift Transport while installing driver?

@Ravikumar Kumashi

[#8]

@Ravikumar Kumashican you try with http or binary, if it helps

[#9]

use authentication mechanism 'use name' and transport binary

@Ravikumar Kumashi

[#10]

@Rajkumar Singh

I am thinking there might be some issue Hive ODBC driver set up why becuase when 'hive.metastore.sasl.enabled' was set to false in hive-site.xml i was getting below error

But when 'hive.metastore.sasl.enabled' was set to true in hive-site.xml i am getting below error

In both case it is just vice versa if u observer the error message.

Is there something we can set it in hive ODBC driver config file to set SASL to true

[#11]

@slachterman

Yes 192.168.228.128 is the adress i am using.

I used command line to connect to that host it is taking very long time, It is almost more than 30 minutes