Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Qliksense: SQL limits to Select number of records?

Hi,

I was trying to select and load the following from data loader:

[MyTable]:
LOAD
id,
date

SELECT* from My Table WHERE id = "1" AND date LIKE "2018-12-06%";

I encounter the following error message:

 

MyTable<< QueryResult
---
The following error occurred:
QVX_UNEXPECTED_END_OF_DATA: ERROR [HY000] [Qlik][MySQL] Query execution was interrupted, maximum statement execution time exceeded
---
The error occurred here:
[MyTable]:
LOAD
id,
date

The same select command is able to complete in my sql server but failed in Qlik Sense Data loading. 

MyTable has 47474961  records. 

After I reduced the number of records to 209128 records and the error message when I load the data in Qlik Sense. 

I could not find the documentation on the max number of records that Qliksense can select.  Is there a maximum statement execution time settings in Qlik Sense?

 

8 Replies
Highlighted
Creator II
Creator II

Re: Qliksense: SQL limits to Select number of records?

[MyTable]:
LOAD
id,
date;
SQL
SELECT* from My Table WHERE id = "1" AND date LIKE "2018-12-06%";

try above code
Highlighted

Re: Qliksense: SQL limits to Select number of records?

I suggest you to use this for first part.

SQL SELECT* from My Table WHERE id = "1" AND date LIKE "2018-12-06%";

 

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator
Creator

Re: Qliksense: SQL limits to Select number of records?

Hi,

Using the code below:

SQL SELECT* from MyTable WHERE id = "1" AND date LIKE "2018-12-06%";

I'm still getting the same error:

The following error occurred:
QVX_UNEXPECTED_END_OF_DATA: ERROR [HY000] [Qlik][MySQL] Query execution was interrupted, maximum statement execution time exceeded
---
The error occurred here:
[MyTable]:
LOAD
id,
date ---

I also tried:

SQL SELECT* from MyTable WHERE id = "1";

 The results is the same even without the second condition.

The following error occurred:
QVX_UNEXPECTED_END_OF_DATA: ERROR [HY000] [Qlik][MySQL] Query execution was interrupted, maximum statement execution time exceeded
---
The error occurred here:
[MyTable]:
LOAD
id
---
Highlighted
Partner
Partner

Re: Qliksense: SQL limits to Select number of records?

LOAD *;
SQL SELECT *
FROM MyTable WHERE id = "1" AND [date] > '2018-12-06';

Try above

Highlighted
Creator
Creator

Re: Qliksense: SQL limits to Select number of records?

Hi,

I tried your code and got the message below:

The following error occurred:
Field 'id' not found
The error occurred here:
?
Highlighted
Partner
Partner

Re: Qliksense: SQL limits to Select number of records?

Try edit the Mysql connection Option:

miscellaneous 

'Query Timeout'

  change  value = 30 to 0 

 

 

qlik is best BI tool
Highlighted
Partner
Partner

Re: Qliksense: SQL limits to Select number of records?

Query Timeout:
Used to specify the number of seconds that the execution of an SQL query can take before it is terminated and an exception is raised. If the value is 0, no timeout will happen. The default value is 0.

qlik is best BI tool
Highlighted
Contributor
Contributor

Re: Qliksense: SQL limits to Select number of records?

Thank you. This sorted it out.