Installing the DataDirect Hive ODBC driver
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:
>> ksh ./unixmi.ksh
- Follow the prompts to complete the installation.
-
Perform basic testing of the driver:
>> ./ddtestlib /opt/Progress/DataDirect/Connect64_for_ODBC_71/lib/ddhive27.so