Hortonworks Sandbox Forum

Hive ODBC Connection Issue

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

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #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

    #53170
    Pankaj Narang
    Participant

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

    Regards
    Pankaj

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

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

    #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

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

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

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.