Hive / HCatalog Forum

Hive ODBC Connection

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

to create new topics or reply. | New User Registration

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

    #30493
    Seth Lyubich
    Moderator

    Hi Sudhir,

    Thanks for letting us know.

    Seth

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

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

    #36131
    Mark Malter
    Member

    I set my port to 10000 and it works!

    #36132
    Mark Malter
    Member

    Thank you Sudhir.

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

    #36259
    Sudhir Nair
    Member

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

    #36261
    Mark Malter
    Member

    I created the ODBC DSN on 64 bit.

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

    #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

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

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.