Home Forums Hive / HCatalog ODBC Driver – Error from Hive:ETIMEDOUT

Tagged: ,

This topic contains 8 replies, has 4 voices, and was last updated by  Seth Lyubich 8 months, 2 weeks ago.

  • Creator
    Topic
  • #26940

    I have installed Hive ODBC driver version 1.2.0.1005 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.
    TESTS COMPLETED WITH ERROR.

    Here is the configuration I used in the ODBC driver
    Host: 153.64.234.161
    port : 9083
    Database:default
    Hive Server Type: Hive Server 2
    Mechanism: Username
    Username:root

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

    Please help me with this.

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

You must be logged in to reply to this topic.

  • Author
    Replies
  • #30492

    Seth Lyubich
    Keymaster

    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.

    Thanks,
    Seth

    Collapse
    #30468

    Sudhir Nair
    Member

    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.

    Collapse
    #30357

    Sudhir Nair
    Member

    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

    Collapse
    #27886

    tedr
    Moderator

    Hi Vineeta,

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

    Thanks,
    Ted.

    Collapse
    #26970

    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 log4j.properties files.
    Logging initialized using configuration in jar:file:/usr/lib/hive/lib/hive-common-0.9.0.15.jar!/hive-log4j.properties
    Hive history file=/tmp/root/hive_job_log_root_201306050945_651577383.txt
    hive> show databases;
    OK
    dalab
    datest
    default
    Time taken: 0.3 seconds

    Collapse
    #26965

    tedr
    Moderator

    Hi Vineeta,

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

    Thanks,
    Ted.

    Collapse
    #26944

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

    Collapse
    #26942

    tedr
    Moderator

    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.

    Thanks,
    Ted.

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