Home Forums Hortonworks Sandbox Hive ODBC Connection Issue

Tagged: , ,

This topic contains 7 replies, has 7 voices, and was last updated by  Vic Liu 6 months, 3 weeks ago.

  • Creator
    Topic
  • #48328

    Mahesh Godi
    Participant

    I’m getting following error message while configuring Hive ODBC for Sand Box.

    ———————————-
    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.

    ———————————-

    Preference ->Network ->Host only network ->DCHP Server
    what information i need to Enter for
    1) Server Address ?
    2) Server Mask
    3) Lower Address bound
    4) Upper address bound.

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

You must be logged in to reply to this topic.

  • Author
    Replies
  • #54709

    Vic Liu
    Participant

    I am having similar issue but different error messages (following). I am trying to connect using “Kerberos” authentication.

    Driver Version: V1.3.19.0013

    Running connectivity tests…

    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][HiveODBC] (34) Error from Hive: SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure. Minor code may provide more information (No credentials cache found).

    TESTS COMPLETED WITH ERROR.

    Collapse
    #53988

    Vijaya Kumar
    Participant

    Thanks Dave. I rectified myself by removing one of the two host-only adapters and resolving the IP conflicts. The ODBC tutorial is perfect. Thanks.

    Collapse
    #53948

    Dave
    Moderator

    Hi,

    10060 is connection timed out.
    Can you connect via JDBC if you run from the beeline command line on the sandbox itself?
    If so, then you should look at the port forwarding from your machine to the sandbox (found in the network settings of the VM) and also check your firewall locally.

    Thanks

    Dave

    Collapse
    #53874

    Vijaya Kumar
    Participant

    Iam using Win 8.1 and Sandbox version 2.0. Iam also getting the same error. I followed the exact steps in your tutorials, please help.

    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.

    Collapse
    #53631

    Johnny Wang
    Participant

    i am getting the same error here and i followed exactly the same tutorial, but still i am getting this error

    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.

    ————————————————————————————————————————————–

    i am wondering if this is the issue from windows 8 as the tutorial is on Windows 7. Please help or i am stucking my evaluation here , thanks all.

    Collapse
    #53170

    Pankaj Narang
    Participant

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

    Regards
    Pankaj

    Collapse
    #48538

    iandr413
    Moderator

    Hi Mahesh,
    When installing the ODBC driver, did you utilize one of the tutorials for the sandbox? What steps did you take to install and configure the ODBC driver?

    Ian

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