The Hortonworks Community Connection is now live. A completely rebuilt Q&A forum, Knowledge Base, Code Hub and more, backed by the experts in the industry.

You will be redirected here in 10 seconds. If your are not redirected, click here to visit the new site.

The legacy Hortonworks Forum is now closed. You can view a read-only version of the former site by clicking here. The site will be taken offline on January 31,2016

Hive / HCatalog Forum

Attempting ODBC connection to Hive

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

  • Author
  • #15722
    Larry Liu


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

    Here is the guide:




    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.



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


The forum ‘Hive / HCatalog’ is closed to new topics and replies.

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

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.