HDP on Windows – Other Forum

ODBC connection error 10060

  • #54735
    Tom Littlejohn
    Participant

    Hello,

    I have been struggling with this for a while. I assume it is a network setup issue on the virtual machine, but haven’t been able to figure it out.

    Host: Windows 8 laptop
    VM: VirtualBox, Hortonworks Sandbox

    VirtualBox Network Settings:
    Host-only Adapter: 192.168.170.1, 255.255.255.0
    DHCP Server: 192.168.170.1, 255.255.255.0, 192.168.170.101, 192.168.170.110

    Virtual Machine Network Settings:
    Adapter 1: NAT
    Adapter 2: Host-only Adapter

    After Virtual Machine startup, eth1 settings:
    inet addr: 192.168.170.102

    ODBC Driver settings (32-bit Windows):
    Host: 192.168.170.102
    Port: 10000
    Database: default
    Hive Server Type: Hive Server 2
    Auth/Mechanism: User Name
    User Name: sandbox

    Results of ODBC Test:
    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.

    Thanks for your help,
    Tom

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #54737
    #54759
    Robert Molina
    Moderator

    Hi Tom,
    Can you verify the hiveserver2 port where the hiveserver2 process is running?

    Regards,
    Robert

    #54781
    Tom Littlejohn
    Participant

    hive.server2.thrift.http.path cliservice
    hive.server2.thrift.http.port 10001
    hive.server2.thrift.max.worker.threads 500
    hive.server2.thrift.min.worker.threads 5
    hive.server2.thrift.port 10000

    #54889
    IngEnsi
    Participant

    Try to change the Port to 10001 and let us know if it works.

    #54940
    Tom Littlejohn
    Participant

    Hello. I changed the Port in the ODBC driver setup to 10001, but I still get the same error.

    Any other ideas?

    Thanks for your help!

    Tom LJ

    #72092
    Rupert Bailey
    Participant

    I had problems setting up JDBC with Sandbox 2.2.4.2 and it was because it “wasn’t enough” just to restart stale Hive configs. I restarted the entire Sandbox and JDBC using http/cliservice/port10001 then worked.

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.