Home Forums Hive / HCatalog Attempting ODBC connection to Hive

This topic contains 3 replies, has 4 voices, and was last updated by  tedr 1 year, 8 months ago.

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

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

You must be logged in to reply to this topic.

  • Author
    Replies
  • #22872

    tedr
    Moderator

    Hi

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

    Thanks,
    Ted.

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

    Collapse
    #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

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