Hive / HCatalog Forum

ODBC Driver connection problem

  • #13121
    tokan
    Member

    Hello,

    In my environment both hiveserver and metastore running. I can connect to hive with cli.
    However when I try to connect through Hortonworks ODBC driver I’m getting the following error message.

    Driver Version: V1.0.0.1009
    
    Running connectivity tests...
    
    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][ODBC] (10360) Invalid connection string.
    
    TESTS COMPLETED WITH ERROR.
    

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #13122
    Seth Lyubich
    Moderator

    Hi Tokan,

    Thank you for using HDP and our ODBC drivers.

    Please make sure that your hiveserver is running on port 10000. You can use command below to make sure that Hive processes are bound to port 9083 and 10000:

    netstat -anp|grep ’9083\|10000′

    Also, please make sure that hive server is reachable from ODBC client machine. You can try telneting to hiveserver IP on port 10000 to test connectivity.

    Additionally, please make sure that you are providing correct login information for ODBC driver such server IP and port (10000 be default).

    You can also find more on ODBC drivers from post below:

    http://hortonworks.com/community/forums/topic/hive-odbc-driver/page/2/

    Hope this helps,

    Thanks,
    Seth

    #41690

    Have you been able to resolve this? I’ve got the same problem but was not able to find a solution.

    Thanks

    #41956
    Yi Zhang
    Moderator

    Hi Onder,

    Have you tried Seth’s suggestions.

    Thanks,
    Yi

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.