Qliksense: SQL limits to Select number of records?

[wuming79]

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?

[poojashribanger]

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

try above code

[Anil_Babu_Samineni]

I suggest you to use this for first part.

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

[wuming79]

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

[nsetty]

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

Try above

[wuming79]

Hi,

I tried your code and got the message below:

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

[TZ-Lucas]

Try edit the Mysql connection Option:

miscellaneous 

'Query Timeout'

  change  value = 30 to 0 

[TZ-Lucas]

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.

[jakfourie1]

Thank you. This sorted it out.