Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Sammy29
Partner
Partner

ODBC Hive Connector is sending back the table.field name instead of field in Qliksense.

Hi all , 

I am facing a weird issue where in ODBC hive connector (version 2.6.9) is sending the table.field instead of field and due that load script is failing . I have found the article related to the issue on qlik support portal. 

https://support.qlik.com/articles/000069974

Please refer to below example to understand better.

Example : 

LOAD FIELD1, FIELD2, FIELD3 ; 

SQL SELECT FIELD1,

                           FIELD2,

                          FIELD3 

 FROM HIVE. TABLE ; 

In the above script, ODBC Hive connector driver is sending TABLE.FIELD1 , TABLE.FIELD2 and TABLE.FIELD3 and due to that LOAD script is failing . This is the expected behavior as per the article on the qlik support . 

However, I would like to check if anyone has faced the similar issue recently and any workaround other than changing the Load script as sent by driver. Because we have already developed the applications using csv/excel files generated by hive system and do not want to change the script for all the application . 

Thanks .

BR,

S

0 Replies