This topic
explains how to install the DataDirect driver for Apache Hive, which is a fully compliant ODBC
driver that supports multiple Hadoop distributions.
Before you begin
KornShell (ksh) must be installed on the Unica Campaign listener (analytic) server.
Procedure
-
Obtain the Progress DataDirect Connect ODBC driver (Progress DataDirect Connect64(R) for ODBC
Release 7.1.5) for Apache Hadoop Hive: https://www.progress.com/products/data-sources/apache-hadoop-hive
-
Download and install the DataDirect Hive driver on the
Unica Campaign listener (analytic server):
PROGRESS_DATADIRECT_CONNECT64_ODBC_7.1.5_LINUX_64.tar.Z
[DataDirectNew]# gunzip PROGRESS_DATADIRECT_CONNECT64_ODBC_7.1.5_LINUX_64.tar.Z
[DataDirectNew]# tar -xvf PROGRESS_DATADIRECT_CONNECT64_ODBC_7.1.5_LINUX_64.tar
-
Run the following command to start the installation:
-
Follow the prompts to complete the installation.
-
Perform basic testing of the driver:
>> ./ddtestlib /opt/Progress/DataDirect/Connect64_for_ODBC_71/lib/ddhive27.so