Hive / HCatalog Forum

ODBC Driver – Error from Hive:ETIMEDOUT

  • #26940

    I have installed Hive ODBC driver version on my windows host machine. Hadoop version 1.0.3 resides on Linux server. My goal is to test connectivity using Hive odbc driver on windows to the hive server on linux. I could check that on the linux server there is a process on port 9083 which is listening. I strongly believe it is the hive port.

    From my windows client machine when I try to connect to the Hive on linux server I get the following error
    Test Results
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][Hardy] (34) Error from Hive: ETIMEDOUT.

    Here is the configuration I used in the ODBC driver
    port : 9083
    Hive Server Type: Hive Server 2
    Mechanism: Username

    I have earlier tried to user Hive Server Type = Hive Server 1 but it did not work either.

    Please help me with this.

to create new topics or reply. | New User Registration

  • Author
  • #26942

    Hi Vineeta,

    If the hadoop cluster you re trying to connect to is a HDP installed cluster, try using the ‘hive’ user rather than the root user.



    I tried using the hive user but it doesn’t work. I still get the same error :(


    Hi Vineeta,

    Are you able to connect to the hive server via the command line (using putty or cygwin shell)?



    Hi Ted,

    Yes I am able to connect to the hive server using putty. I can also run commands like below
    hive> doral:/home # hive
    WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in all the files.
    Logging initialized using configuration in jar:file:/usr/lib/hive/lib/hive-common-!/
    Hive history file=/tmp/root/hive_job_log_root_201306050945_651577383.txt
    hive> show databases;
    Time taken: 0.3 seconds


    Hi Vineeta,

    Sorry about the delay in responding. Could you try connecting instead to port 10000?


    Sudhir Nair

    I get the same error while connecting to my 3 Node HDP for windows cluster!
    The Hive service is running and I am able to run queries under the command line utility on the server

    Sudhir Nair

    OK, I got the ODBC to work.

    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.

    Seth Lyubich

    Hi Sudhir,

    Thanks for letting us know that you were able to resolve your issue. Vineeta, please let us know if Sudhir’s instructions helpful.


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.