Home Forums HDP on Windows – Installation How to Configure Hive Server 2 for ODBC Connection on HDP 1.3 on Windows

Tagged: ,

This topic contains 2 replies, has 2 voices, and was last updated by  Field Wachi 8 months ago.

  • Creator
    Topic
  • #33385

    Seth Lyubich
    Keymaster

    By default, the Hive Server 2 service on Windows starts in ‘HTTP’ mode. In order to enable the Hortonworks ODBC driver, the Hive Server 2 service needs to run in ‘Thrift’ mode. Please see steps below on how to configure Hive Server 2 to run in ‘Thrift’ mode.

    1. Stop any Hive running Hive services:

    - hiveserver2
    - hiveserver1
    - hwi
    - metastore

    2. Configure the HiveServer2 service to run in ‘Thrift’ mode

    - locate hive-site.xml located in %HIVE_CONF_DIR%.

    3. Locate hive.server2.servermode property and set it to Thrift. See example below:

    hive.server2.servermode
    thrift
    HiveServer server type: thrift or http

    4. Restart Hive Services from step 1:

    - hiveserver2
    - hiveserver1
    - hwi
    - metastore

    Thanks,
    Seth

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

You must be logged in to reply to this topic.

  • Author
    Replies
  • #44375

    Field Wachi
    Participant

    Problem has been resolved.
    UserName : Hadoop and open the firewall…..

    Collapse
    #44374

    Field Wachi
    Participant

    I encountered a problem.

    My hive-site.xml
    hive.server2.servermode : thrift
    hive.server2.thrift.port : 10001
    javax.jdo.option.ConnectionUserName : hive
    javax.jdo.option.ConnectionPassword : hive

    My Hortonworks Hive ODBC Driver Configuration
    host : HDPSERVER
    post : 10001
    database : default
    hive server type : hive server 2
    mechainism : username
    username :hive

    Test Results shows
    Driver Version : v1.2.0.1005
    Running connectivity tests…
    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][Hardy] (34) Error from Hive: connect() failed: errno = 10060.
    TESTS COMPLETED WITH ERROR.

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