Home Forums Hive / HCatalog Hive ODBC Connection

Tagged: ,

This topic contains 12 replies, has 6 voices, and was last updated by  Azure Expert 5 months, 3 weeks ago.

  • Creator
    Topic
  • #30038

    Sudhir Nair
    Member

    I am getting this error when testing ODBC connectivity (Hortonwork 64 Bit ODBC)

    “Failed to establish connection
    SQLSTATE: HY000[Hortonworks][Hardy] (34) Error from Hive: ETIMEDOUT.
    TESTS COMPLETED WITH ERROR.”

    I am trying to connect to a 3 node HDP windows cluster (Port 9083)
    I have no issues using queries on the server hive commnad prompt

    Thanks
    Sudhir Nair

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

You must be logged in to reply to this topic.

  • Author
    Replies
  • #51129

    Azure Expert
    Participant

    I’m getting following error
    Driver Version: V1.2.0.1005

    Running connectivity tests…

    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][Hardy] (34) Error from Hive: connect() failed: errno = 10061.

    TESTS COMPLETED WITH ERROR.

    ——————-
    I’m configuring ODBC32 version to my Hortonwork sandbox 2.0. My cluster is up and running, tried to give 127.0.0.1 for host name, hiver server type : hiveserver2, port – 10001, username – root. Also changed the hostname to : sandbox.hortonworks.com but did not work. How can I fix this error.

    Collapse
    #45739

    Hi Sudhir,

    I am still getting the same error which you got at first time.
    I have done all the things which you specified in the site but still no luck.
    Could you please guide me over this

    Thanks
    Srinu

    Collapse
    #44132

    Srikanth Guthi
    Participant

    hi,

    I’m trying to test the ODBC connection and I’m getting the same error. Here I’m trying to connect to Hive Server 1 as my Hortonworks Hadoop version is 1.0.3 which don’t have Hive Server 2.

    Thank you.

    Collapse
    #36261

    Mark Malter
    Member

    I created the ODBC DSN on 64 bit.

    Collapse
    #36259

    Sudhir Nair
    Member

    Did you create the ODBC DSN on 32 bit o4 64 bit ?

    Collapse
    #36133

    Mark Malter
    Member

    Now when I open excel (I have 2010) > Data > From other sources > From Microsoft Query the Choose Data Source dialog box opens, but the only choices are:

    dBASE Files*
    Excel Files*
    MS Access Database*

    but no choice for the Hortonworks ODBC data source.

    Collapse
    #36132

    Mark Malter
    Member

    Thank you Sudhir.

    Collapse
    #36131

    Mark Malter
    Member

    I set my port to 10000 and it works!

    Collapse
    #36130

    Sudhir Nair
    Member

    Are you trying to connect to Hadoop Windows or Lunix?
    My instructions for ODBC are for Hadoop on Widows

    1. Under Port, enter the port of the Hive Server 2 service. By default, the Hive Server port is set to 10001.
    2. Choose Username for authentication, and enter ‘Hadoop’ as the user name.

    Collapse
    #36122

    Mark Malter
    Member

    I’m getting the same error as Sudhir. I tried using both port 10000 and 10001 with username Hadoop. My host is the same ip address that I use for my sandbox (127.0.0.1:8888 in my case).
    I have sandbox 1.3 installed and the tutorial says that 1.2 is a prerequisite, but I assume that doesn’t matter.
    Please advise.

    Collapse
    #30493

    Seth Lyubich
    Keymaster

    Hi Sudhir,

    Thanks for letting us know.

    Seth

    Collapse
    #30469

    Sudhir Nair
    Member

    OK, I got the ODBC to work.

    Key things to consider!
    1. Under Port, enter the port of the Hive Server 2 service. By default, the Hive Server port is set to 10001.
    2. Choose Username for authentication, and enter ‘Hadoop’ as the user name.

    Full set of instructions
    Download the Windows 64-bit Hortonworks ODBC driver
    Execute the MSI and follow the instructions to install the ODBC driver.
    Set up an ODBC DSN using the following instructions:
    For 64-bit ODBC driver: Open the 64-bit ODBC Administrator pane.
    Navigate to the System DSN tab.
    Click Add, select the Hortonworks Hive driver and click Finish.
    Configure the driver using the following instructions:
    Under Host, provide the hostname of the cluster node that runs the Apache Hadoop hiveserver2 service.
    Under Port, enter the port of the Hive Server 2 service. By default, the Hive Server port is set to 10001.
    Choose Username for authentication, and enter ‘Hadoop’ as the user name.
    Click Ok.

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