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.
Please refer to below example to understand better.
LOAD FIELD1, FIELD2, FIELD3 ;
SQL SELECT FIELD1,
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 .