Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
wuming79
Contributor

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?

 

5 Replies
poojashribanger
Contributor 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

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)
wuming79
Contributor

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
---
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

wuming79
Contributor

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:
?