You can translate the question and the replies:

How can we keep "Stop query when the limit is reached" option to checked by default?

Support Team, Is there any way we can set this option always ON in VQL Shell or in CONTEXT clause? This is to avoid query execution further after limit rows have been reached. Thanks,
5.5
user
07-06-2016 20:12:21 -0400
code

1 Answer

Hi! In order to limit the rows of a query execution I would use the VQL *Limit* clause in the query as an alternative for the *“Stop query when the limit is reached”* option. For example to limit the results to 10 rows the query would be like ``` Select * from view1 limit 10; ``` Hope this helps!
Denodo Team
08-06-2016 11:17:59 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here