Hortonworks Hive ODBC Driver data source testing failed

to create new topics or reply. | New User Registration

This topic contains 2 replies, has 3 voices, and was last updated by  Grant Liu 1 year, 10 months ago.

  • Creator
    Topic
  • #22865

    Hi there,

    We have installed HDP Version: 1.1.0-160 with following parameters…
    msiexec /i “e:\hdp\hdp-1.1.0-160.winpkg.msi” /lv “e:\hdp\logs\hdp.log” HDP_LAYOUT=”e:\hdp\clusterproperties.txt” HDP_DIR=”e:\hdp\hadoop” DESTROY_DATA=”no”

    two nodes(master and slave) small cluster have been created on Windows server 2012 64bit and following is my cluster information…

    #Log directory
    HDP_LOG_DIR=e:\hdp\logs
    #Data directory
    HDP_DATA_DIR=e:\hdp\data
    #Hosts
    NAMENODE_HOST=hdpmaster
    SECONDARY_NAMENODE_HOST=hdpmaster
    JOBTRACKER_HOST=hdpmaster
    HIVE_SERVER_HOST=hdpmaster
    OOZIE_SERVER_HOST=hdpmaster
    TEMPLETON_HOST=hdpmaster
    SLAVE_HOSTS=workernode1
    #Database host
    DB_FLAVOR=derby
    DB_HOSTNAME=hdpmaster
    #Hive properties
    HIVE_DB_NAME=hive
    HIVE_DB_USERNAME=hive
    HIVE_DB_PASSWORD=hive
    #Oozie properties
    OOZIE_DB_NAME=oozie
    OOZIE_DB_USERNAME=oozie
    OOZIE_DB_PASSWORD=oozie
    Driver Version: V1.2.0.1005

    We have also installed MS Excel 2013, MSSQL Server 2012 and HortonworksHiveODBC64 on master node.

    A HDP DSN has been set up with following details….
    Host:hdpmaster
    Port:10000
    Database:default
    Hive Server Type: Hive Server 1
    Authentication: No Authentication
    Besides that we have started all services including Apache Hadoop hiveserver
    and execute command hive -h hdpmaster -p 10000 and get following prompt.
    [hdpmaster:10000] hive>
    However, the results are as follows….
    Driver Version: V1.2.0.1005

    Running connectivity tests…

    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][Hardy] (22) Error from ThriftHiveClient: No more data to read.

    TESTS COMPLETED WITH ERROR.

    If we set Hive Server Type: 2 in the DSN setup

    the results are….
    Driver Version: V1.2.0.1005

    Running connectivity tests…

    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][Hardy] (34) Error from Hive: No more data to read..

    TESTS COMPLETED WITH ERROR.

    Please help me out.

    Thanks
    Mahabubur Rahaman
    Orion Informatics Ltd,
    Dhaka, Bangladesh

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

You must be to reply to this topic. | Create Account

  • Author
    Replies
  • #29724

    Grant Liu
    Participant

    I’ve seen this too, Ted with our 2.0 CP. Still troubleshooting, but the error above suggests connection was already established, otherwise you get a timeout.

    Collapse
    #22876

    tedr
    Moderator

    Hi Mahaburbur,

    Have you made sure that the ports for Hive are open on the firewall? You can test this by telnetting to the box at ports 9083 & 10000.

    Thanks,
    Ted.

    Collapse
Viewing 2 replies - 1 through 2 (of 2 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.