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]

Do you see the same behavior when you specify beeline -u jdbc:hive2://localhost:10000/default

What does the following return on the sandbox?

nc -zv 192.168.228.128 10000

[#3]

@slachterman

When i localhost instead of 192.168.228.128 it is same behaviour.

when i use nc -zv 192.168.228.128 10000 it is succeded

[#4 · Accepted solution]

Interesting, I don't understand why you can't connect via beeline if the service is up and you can connect on this port. Can you please confirm that you can connect to Hive View via Ambari (and submit queries successfully)?

One thing to check is that the sandbox has enough resources to provide a YARN container for Hive. You can check the ResourceManager UI by navigating to http://192.168.228.128:8088 and seeing if the consumed memory/CPU is exceeding the resources of your cluster. You can also list what YARN apps are running by yarn application -list from the sandbox shell.

[#5]

@slachterman i just allocated 2GB Ram for my virtual machine for sandbox and http://192.168.228.128:8088 is taking more time to connect to ambari.

[#6]

@slachterman Thanks, I increased my VM RAM to 4GB from 2GB and now i am able to connect to Hive server.

[#7]

Good to hear, thanks for the follow up information @Ravikumar Kumashi.