topic Re: ODBC driver issue for Hadoop endpoint in Qlik Replicate

ODBC driver issue for Hadoop endpoint

Megha_More — Wed, 07 Feb 2024 06:23:06 GMT

Hi Team,

We are facing below error message while establishing endpoint connection for Hadoop on Linux environment

Failed to prepare Hive ODBC Parameter.

No drivers were found. Failed to find Hive ODBC driver.

Though we have configured the Cloudera ODBC driver (version 2.06.09.1009).

Can you please help with the same.

Regards,

Megha

Re: ODBC driver issue for Hadoop endpoint

john_wang — Wed, 07 Feb 2024 07:01:52 GMT

Hello @Megha_More ,

Thanks for reaching out to Qlik Community!

Please check below files:

1- Make sure you have the proper driver entry in file "/etc/odbcinst.ini"

2- Make sure the 64-bit ODBC Driver was installed. You may try to test the connectivity by run command "isql" on Linux. If isql works then Replicate should work too.

3- In Qlik Replicate, use the internal parameter "driver" and input the corresponding same entry name in file "/etc/odbcinst.ini"

4- Make sure to add ODBC Driver installation libs folder to LD_LIBRARY_PATH in file "site_arep_login.sh"

5- Try to restart Replicate Service

Hope this helps.

John.

Re: ODBC driver issue for Hadoop endpoint

Megha_More — Wed, 07 Feb 2024 07:55:43 GMT

Hi @john_wang ,

Thank you for the quick response.

Can you please guide us on the point 3.

We have specify below entries in /etc/odbcinst.ini

DriverManagerEncoding=UTF-16

ODBCInstLib=libodbcinst.so

After entering same values under internal parameter driver, We got an error that is saying driver is not found.

Could you please let us know which entries should be enter under internal parameter and above mentioned entries is correct or not ?

Regards,

Megha

Re: ODBC driver issue for Hadoop endpoint

john_wang — Wed, 07 Feb 2024 12:14:42 GMT

Hello @Megha_More ,

Looks to me the /etc/odbcinst.ini is inaccurate. A typical file contents include lines:

[Cloudera ODBC Driver for Apache Hive 64-bit]
Description=Cloudera ODBC Driver for Apache Hive (64-bit)
Driver=/opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so

Where the internal parameter "driver" (in step 3) value should be set to "Cloudera ODBC Driver for Apache Hive 64-bit" (without double-quotes).

BTW, please make sure the "isql" works prior to test the connectivity in Qlik Replicate.

thanks,

John.

Re: ODBC driver issue for Hadoop endpoint

Megha_More — Fri, 09 Feb 2024 05:24:02 GMT

Hi @john_wang ,

Issue resolved!!

Regards,

Megha

Re: ODBC driver issue for Hadoop endpoint

john_wang — Fri, 09 Feb 2024 06:03:27 GMT

Hello @Megha_More ,

Glad to hear that, thank you so much for your feedback!

Best Regards,

John.