question Re: HOW TO INSTALL AND CONFIGURE THE HORTONWORKS ODBC DRIVER ON WINDOWS 7 in Archives of Support Questions (Read Only)

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

ravikumashi — Fri, 16 Sep 2022 10:28:18 GMT

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-windows-7/

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

ravikumashi — Thu, 30 Jun 2016 14:30:17 GMT

@slachterman Could you please help me with above question

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

rajkumar_singh — Thu, 30 Jun 2016 14:39:12 GMT

@Ravikumar Kumashi the documentation you followed looked far old and it is meant for odbc driver version 1.2.0.*, what authentication mechanism you are currently using with hiveserver2?

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

ravikumashi — Mon, 19 Aug 2019 11:56:36 GMT

@Rajkumar Singh I new to Hortonworks, I am just trying to follow the tutorials given in the Hortonworks.I am using User Name as the Authentication mechanism, please see below

Do I need to follow different link or steps ?

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

rajkumar_singh — Thu, 30 Jun 2016 14:58:29 GMT

can you check the following property value either from amabri or in hive-site.xml, it should be configured in any of the following option

NONE,KERBEROS,PAM,LDAP,CUSTOM

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

ravikumashi — Thu, 30 Jun 2016 15:25:50 GMT

@Rajkumar Singh How to find the hive-site.xml path in HortonWorks Sandbox and how to see the these properties in hive-site.xml, sorry i am new to Hortonworks sandbox and my question might sounds silly

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

rajkumar_singh — Thu, 30 Jun 2016 15:39:05 GMT

/etc/hive/conf/

@Ravikumar Kumashi

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

ravikumashi — Mon, 19 Aug 2019 11:56:28 GMT

@Rajkumar Singh

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

ravikumashi — Mon, 19 Aug 2019 11:56:20 GMT

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

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

rajkumar_singh — Thu, 30 Jun 2016 17:42:54 GMT

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

@Ravikumar Kumashi

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

ravikumashi — Thu, 30 Jun 2016 17:48:36 GMT

@Rajkumar Singh Binary and HTTP

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

rajkumar_singh — Thu, 30 Jun 2016 17:56:44 GMT

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

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

ravikumashi — Mon, 19 Aug 2019 11:56:01 GMT

@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

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

rajkumar_singh — Thu, 30 Jun 2016 18:22:24 GMT

use authentication mechanism 'use name' and transport binary

@Ravikumar Kumashi

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

ravikumashi — Mon, 19 Aug 2019 11:55:48 GMT

@Rajkumar Singh

for username authentication there isn no Binary option, so i tried with Username and password authentication with Thrift Transport option as Binary and HTTP still getting below error

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

ravikumashi — Mon, 19 Aug 2019 11:55:40 GMT

@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

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

slachterman — Thu, 30 Jun 2016 21:01:36 GMT

@Ravikumar Kumashi are you able to connect using that host, port, and username using the hive command line client on the sandbox?

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

ravikumashi — Thu, 30 Jun 2016 21:11:42 GMT

@slachterman how can we do it from command line, I mean what is the command i need to use in sandbox

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

slachterman — Thu, 30 Jun 2016 21:32:52 GMT

beeline -u jdbc:hive2://192.168.228.128:10000/default

Is 192.168.228.128 the address you are using to reach the sandbox from your windows PC for other protocols, like SSH?

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

ravikumashi — Mon, 19 Aug 2019 11:55:27 GMT

@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