ODBC Connection Error

to create new topics or reply. | New User Registration

This topic contains 2 replies, has 2 voices, and was last updated by  Srikanth Guthi 1 year, 4 months ago.

  • Creator
    Topic
  • #44223

    Srikanth Guthi
    Participant

    I have installed Hive ODBC driver version 1.2 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. In my hive-site.xml I found hive port as 9083. Hive version on hadoop cluster is 0.9. It does not have hive
    server2 feature.

    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: IP
    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.

    Do we need to do any setup for ODBC on linux server before we install the ODBC driver on windows machine?

    Please help me with this.

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

You must be to reply to this topic. | Create Account

  • Author
    Replies
  • #44846

    Srikanth Guthi
    Participant

    Hi Yi,

    Thank you. I had to start the hive server and it worked. Thanks.

    Collapse
    #44805

    Yi Zhang
    Moderator

    Hi Srikanth,

    port 9083 by default is used by hive metastore, not hive server or hive server2. Can you check if hiveserver is really running and if it is, configure odbc to use port 1000 which is the default hive server/2 port if not set to other value?

    Thanks,
    Yi

    Collapse
Viewing 2 replies - 1 through 2 (of 2 total)
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.