Home Forums HDP on Windows – Non Installation issues ODBC connection error 10060

This topic contains 5 replies, has 3 voices, and was last updated by  Tom Littlejohn 5 months, 4 weeks ago.

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

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

You must be logged in to reply to this topic.

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

    Collapse
    #54889

    IngEnsi
    Participant

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

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

    Collapse
    #54759

    Robert Molina
    Moderator

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

    Regards,
    Robert

    Collapse
    #54737
    Collapse
Viewing 5 replies - 1 through 5 (of 5 total)