Hive ODBC Connection Issue

to create new topics or reply. | New User Registration

Tagged: , ,

This topic contains 7 replies, has 7 voices, and was last updated by  Vic Liu 11 months 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 to reply to this topic. | Create Account

  • 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)
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.