Attempting ODBC connection to Hive

I’m using the 64 bit ODBC driver in windows to try to connect to a HW Sandbox.
hadoop version: 1.1.2.21
hive version:1 0.10.0.21
I’ve confirmed I can telnet to 9083 and 10000 from the windows client.
However, when I test via ODBC to port 9083:
Error from thriftHiveClient Invalide Method Name ‘execute’

When I try to connect to port 10000 (the one I believe I need), the driver just hangs…when I cancel it, I get an “Unknown” error

Is there some specific configuration on the server side that I need to have in place to ensure this connectivity?
Any information you can provide is helpful..thanks…I’ve tried to find some documentation on this, but have been unsuccessful.

Topic

[tedrModerator]

Hi

Have you had a chance to try Mark’s suggestions?

Thanks,
Ted.

[mark pettovelloMember]

Ensure that the sandbox VMware image is running
On Windows 7:
Start -> All Programs -> Hortonworks Hive ODBC Driver 1.2 (64-bit) -> 64-bit ODBC Administrator
Highlight your User DSN or the System DSN called Sample Hortonworks Hive DSN and press “Configure” button
Change the field “your_hive_server” to the IP address shown in the sandbox window. Mine is: “192.168.152.128″
Leave the Port as-is: 10000
Change the Hive Server Type to “Hive Server 2″
Change Mechanism to “User Name”
Add the value “root” to the User field
Press the “Test” button
If you see the test results message “TESTS COMPLETED SUCCESSFULLY!” your configuration is correct.

[Larry LiuModerator]

Hi,

Can you please get the log from windows and upload to our ftp server?

Here is the guide:

http://hortonworks.com/community/forums/topic/hmc-installation-support-help-us-help-you/

Thanks

Larry

[Author]

Replies