In addition to the default thrift protocol (binary mode), the driver also supports HTTP mode, which allows you to access Apache Hive data stores using HTTP/HTTPS requests. When HTTP mode is enabled, thrift RPC messages are sent to an endpoint using HTTP transport. HTTP mode is typically employed when there is a need to access data through a proxy server, such as when connecting to a load balancer or a gateway server. Unless otherwise noted, the same features and functionality are supported for both the thrift and HTTP protocols.

To connect to a server using HTTP Mode:

  1. Configure the minimum required options required for a connection:
    • Set the Database Name option to provide the name of the Apache Hive database to which you want to connect.
    • Set the Host Name option to provide the name or the IP address of the server to which you want to connect.
    • Set the Port Number option to provide the TCP port of the primary database server that is listening for connections to the Apache Hive database. The default is 10000.
  2. Set the Transport Mode option to 1 (HTTP).
  3. Optionally, if not using the default HTTP endpoint, set the HTTP Path option to provide the path of the endpoint to be used for HTTP/HTTPS requests. The default is cliservice.
  4. Optionally, if you are sending requests to HTTPS endpoints, set the Encryption Method option to 1 (SSL) to enable SSL data encryption. Data encryption behavior can be further configured using the connection properties described in "TLS/SSL encryption".

The following examples demonstrate a basic configuration of HTTP mode with SSL enabled.

Using a connection URL:

DRIVER=DataDirect 8.0 Apache Hive Wire Protocol;HostName=HiveServer;PortNumber=10001;
DatabaseName=mydb1;EncryptionMethod=1;HTTPPath=mywarehouse;TransportMode=1;

Using the odbc.ini file: 

Driver=ODBCHOME/lib/ivhivexx.so
Description=DataDirect Apache Hive Wire Protocol
DatabaseName=mydb1
EncryptionMethod=1
HTTPPath=mywarehouse
HostName=HiveServer
PortNumber=10001
TransportMode=1