Hi,
The error “**Exception parsing query near ‘limit”’** will occur when the syntax of the query is not proper or it may not be delegated to Virtual DataPort. In Denodo,at this moment Limit is only supported at the end of a SELECT statement to reduce the size of the result set but it cannot be used in subqueries.
As a workaround to Limit the queries you can create the temporary tables.For instance you can refer the below format:
**Syntax:**
CREATE TEMPORARY temporary_table_for_subquery AS <subquery> LIMIT x;
SELECT * FROM ... temporary_table_for_subquery ...
**For your Scenario :**
CREATE TEMPORARY temporary_table_for_subquery AS SELECT * FROM Connections LIMIT 1000;
SELECT * FROM ... temporary_table_for_subquery ...limit 1
For more information , you could take a look at the [“OFFSET, FETCH and LIMIT](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/queries_select_statement/offset_fetch_and_limit/offset_fetch_and_limit#offset-fetch-and-limit)” section under the Virtual DataPort VQL Guide.
Hope this helps!
