Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Knowledge
ODBC connection with many different schema times out
Article Number: 000046732 | Last Modified: 2019/01/10Description
In an ODBC connection to Hortonworks the "create select statement" cannot be used as it is most probably timing out.
At this scenario there are more than 7000 different schema which would take over 20 minutes to load and the GUI timeout for Qlik Sense is around 10 minutes.
It works fine in QlikView as Qlik View loads the tables from one owner (schema), while the same GUI in Qlik Sense loads ALL tables from ALL schema.
Resolution
R&D has responded the following and accepted it as a bug (improvement):
R&D accepts the fact that Qlik Sence needs a new adopted behavior for Hortonworks Hive ODBC driver on how to fetch owners by executing SQLTables("", "%", "", ""). But it is also important that to keep the current Qlik Sense behavior for other drivers.
R&D has also confirmed that Hortonworks ODBC driver for HIVE starts fetching names of owners and all tables when SQLTables("HIVE", "", "", "") is executed (this is the reported problem), but the driver queries only for names of owners when SQLTables("", "%", "", "") is executed. But at the same time there is an advantage of executing SQLTables(<DatabaseName>, "", "", "") towards ODBC driver for SQL Server as it fetches owners for the selected database. If SQLTables("", "%", "", "") is executed then the owners for a default data base are always returned.
Bug ID: QLIK-85451
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us