Attempting ODBC connection to Hive

to create new topics or reply. | New User Registration

This topic contains 3 replies, has 4 voices, and was last updated by  tedr 2 years, 3 months ago.

  • Creator
  • #15721

    IT Support

    I’m using the 64 bit ODBC driver in windows to try to connect to a HW Sandbox.
    hadoop version:
    hive version:1
    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.

Viewing 3 replies - 1 through 3 (of 3 total)

You must be to reply to this topic. | Create Account

  • Author
  • #22872



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



    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: “”
    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 Liu


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

    Here is the guide:



Viewing 3 replies - 1 through 3 (of 3 total)
Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.