ODBC driver issue for Hadoop endpoint

[Megha_More]

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

[john_wang]

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.

[Megha_More]

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

[john_wang · Accepted solution]

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.

[Megha_More]

Hi @john_wang ,

Issue resolved!!

Regards,

Megha

[john_wang]

Hello @Megha_More ,

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

Best Regards,

John.