Home Forums Hive / HCatalog Hortonworks Hive ODBC Driver data source testing failed

This topic contains 2 replies, has 3 voices, and was last updated by  Grant Liu 9 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 logged in to reply to this topic.

  • Author
    Replies
  • #29724

    Grant Liu
    Member

    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)