Hive / HCatalog Forum

Attempting ODBC connection to Hive

  • #15721
    IT Support
    Member

    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.

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #15722
    Larry Liu
    Moderator

    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

    #22721

    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.

    #22872
    tedr
    Moderator

    Hi

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

    Thanks,
    Ted.

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

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.