Hortonworks Sandbox Forum

ODBC Error on HDP 2.0

  • #49142
    Mayank Rathi
    Participant

    Hello ,

    I am getting below error when I am trying to test ODBC connection on Windows 7.

    Driver Version: V1.3.19.0013

    Running connectivity tests…

    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][HiveODBC] (34) Error from Hive: connect() failed: errno = 10060.

    TESTS COMPLETED WITH ERROR.

    Here are the configuration details :

    Description : Sample Hortonworks Hive DSN
    Host : 192.168.56.101
    Port : 10000
    Database : default
    Hive Server Type : Hive Server 2
    Mechanism : User Name
    User Name : sandbox ( tried with user name hive unsuccessfully )

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #49143
    Mayank Rathi
    Participant

    Issue resolved….Please ignore this message :)

    #49949
    Dragan Nesic
    Participant

    How did you solve it?
    I have the exact same issue on my installation?
    I’ve tried everything: opening up the firewall, changing the port, different usernamne setting (“sandbox, “hue”, “hadoop”, “Hadoop”)
    Still have the same issue.
    What did you do to solve it?

    Regard,
    drnes

    #53169
    Pankaj Narang
    Participant

    I am getting the same error. Any resolution to this ?

    Regards
    Pankaj

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.