Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Rising Star

Hi @Rahul Pathak

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

5363-hortonworks-odbc-driver-set-up.png

5364-odbc-issue.png

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

5365-ifconfig.png

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...

1 ACCEPTED SOLUTION

avatar

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.

View solution in original post

25 REPLIES 25

avatar

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

avatar
Rising Star

@slachterman

When i localhost instead of 192.168.228.128 it is same behaviour.

5405-2016-06-30-22-16-10-10156106-remote-desktop-connec.png

when i use nc -zv 192.168.228.128 10000 it is succeded

5404-nc-succeded.png

avatar

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.

avatar
Rising Star

@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.

avatar
Rising Star

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

avatar

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