If you are using the Cloudera ODBC driver to integrate Unica Campaign with a big data source, you must configure the
driver after installing it.
Procedure
-
Modify the ODBC.ini file to specify the Hive server information, using the values shown in the
following example. Be sure to customize the items in bold to match your own
configuration.
Note: Do not enable Native Query mode in the configuration.
[Cloudera_HIVE]
Driver=/opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
Description=Hive Cloudera ODBC Driver
Host=<hostname or ip of Hive server on Hadoop Distribution machine>
Port=<port number of Hive server on Hadoop Distribution machine>
Schema=<database-name>
ServiceDiscoveryMode=0
ZKNamespace=
HiveServerType=2
AuthMech=3
ThriftTransport=1
UseNativeQuery=0
UID=cloudera
GetTablesWithQuery=1
Note: The UID is the user ID of the Cloudera cluster database.
-
Assuming that your ODBC driver is installed in the following location:
/opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
Make the following change in Campaign/bin setenv.sh: Set
LD_LIBRARY_PATH (LIBPATH for AIX®) to include Cloudera LIB and UnixODBC LIB as follows.
-
Open /opt/cloudera/hiveodbc/lib/64/cloudera.hiveodbc.ini
During Cloudera installation, a connectivity option is set by default. To connect Cloudera with
ODBC, you must disable the connectivity option.
Change the following lines in
cloudera.hiveodbc.ini:
# Generic ODBCInstLib
# iODBC
ODBCInstLib=libiodbcinst.so
The updated lines appear as:
# Generic ODBCInstLib
# iODBC
ODBCInstLib=libodbcinst.so