Home Forums Hortonworks Sandbox ODBC Error on HDP 2.0

This topic contains 3 replies, has 3 voices, and was last updated by  Pankaj Narang 3 months, 3 weeks ago.

  • Creator
    Topic
  • #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 )

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

You must be logged in to reply to this topic.

  • Author
    Replies
  • #53169

    Pankaj Narang
    Participant

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

    Regards
    Pankaj

    Collapse
    #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

    Collapse
    #49143

    Mayank Rathi
    Participant

    Issue resolved….Please ignore this message :)

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