Facing error while loading data into Qlik Sense for a particular view in Impala using ODBC driver
Hi all,
I'm facing issue while trying to load data in data load editor from a particular view (select <column names> from view) which fetches around 950K rows from Impala database and we are using the qlik ODBC connector (6.118.2) in Qlik Sense deployed on CDP.
The same query is working fine in Hue CDP editor and Impala CLI.
Do you know if this has ever worked before from that particular view?
Can you please verify if it works in Qlik via an ODBC System DSN connection (based on an Impala ODBC driver)? If yes, I would suggest to open a case in the Qlik Support portal.
I tried to test it in Qlik environment and sometimes the data loading works without any errors and sometimes the data loading fails (and the error in the pic pops up) using this view.
I checked the ODBC logs through Qlik management console and compared the successful loading attempt and unsuccessful loading attempt and I saw that when SequentialThreadCount is around 26 and NumberofCores(effective) is 8, the data loading is happening fine and when the values are less than this, the data loading operation fails. Can you tell me more about these parameters and if they are dependent on network or memory resources?
