Hive / HCatalog Forum

ODBC Driver connection problem

  • #13121


    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.

to create new topics or reply. | New User Registration

  • Author
  • #13122
    Seth Lyubich

    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:

    Hope this helps,



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


    Yi Zhang

    Hi Onder,

    Have you tried Seth’s suggestions.


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.