Configuring the DataDirect Hive ODBC driver

If you are using the DataDirect Hive ODBC driver to integrate IBM® Campaign with a big data source, you must configure the driver after installing it.

Before you begin

Complete the DataDirect driver installation that is described in Installing the DataDirect Hive ODBC driver.

Procedure

  1. Modify the ODBC.ini file to specify the Hive server information, as shown in the example below. You must customize the items in bold to match your own configuration; the values shown below are only examples. Note that RemoveColumnQualifiers must be set to 1.

    [MapRHive]
    Driver=/opt/Progress/DataDirect/Connect64_for_ODBC_71/lib/ddhive27.so
    Description=DataDirect 7.1 Apache Hive Wire Protocol
    ArraySize=16384
    Database=<database-name>
    DefaultLongDataBuffLen=1024
    EnableDescribeParam=0
    HostName=<hostname or ip of Hive server on Hadoop Distribution machine>
    LoginTimeout=30
    LogonID=<username of Hadoop Distribution machine>
    MaxVarcharSize=2147483647
    Password=<password of Hadoop Distribution machine>
    PortNumber=<port number of Hive server on Hadoop Distribution machine>
    RemoveColumnQualifiers=1
    StringDescribeType=12
    TransactionMode=0
    UseCurrentSchema=0
    WireProtocolVersion=0
  2. Assuming that your ODBC driver is installed in the following location:

    /opt/Progress/DataDirect/Connect64_for_ODBC_71

    Make the following changes:

    • Ensure that your LD_LIBRARY_PATH includes the following path: =/opt/Progress/DataDirect/Connect64_for_ODBC_71/lib
    • Ensure that your PATH includes the following path: =/opt/Progress/DataDirect/Connect64_for_ODBC_71/tools
    • Set your ODBCINI variable to point to the correct INI file. For example: ODBCINI=/opt/Progress/DataDirect/Connect64_for_ODBC_71/odbc.ini ; export ODBCINI
    • Set your ODBCINST variable to point to the correct INI file. For example: ODBCINST=/opt/Progress/DataDirect/Connect64_for_ODBC_71/odbcinst.ini ; export ODBCINST
  3. Verify the connectivity of the DataDirect ODBC driver and your Hive-based Hadoop big data system:

    cd /opt/Progress/DataDirect/Connect64_for_ODBC_71/samples/example

    >> ./example

  4. On the Campaign Analytical Server, set the ODBCINI and CAMPAIGN_HOME environment variables in the Campaign/bin/setenv file. Run the IBM Campaign odbctest utility to verify connectivity to IBM Campaign:

    cd <Campaign_Home>/bin

    >> ./odbctest

What to do next

C. Map existing HBase tables to Hive
Parent topic: B. Configure the Hive ODBC Driver