You can translate the question and the replies:

Query in Denodo Datacatalog results in error "Incorrect syntax near 'OFFSET'"

what can I do to solve the problem? Error executing query. Total time 0.02 seconds. QUERY [CACHE] [ERROR] QUERY [JDBC WRAPPER] [ERROR] QUERY [JDBC ROUTE] [ERROR] Received exception with message 'Incorrect syntax near 'OFFSET'.'
06-09-2022 08:56:20 -0400

1 Answer

Hello, The exception error message indicates that the query is being delegated to the source and the source is encountering syntax issues with the OFFSET condition. I would recommend checking the “source configuration” of the data source for the OFFSET clause. To check that, open the data source in the Virtual DataPort Administration Tool and go to **Configuration > Source Configuration**. In there, check the “Delegate Offset Clause” & “Delegate OFFSET Clause Restriction” values. Based on these values, you can make sure that the syntax of the OFFSET clause is correct. You can refer to the documents [Data Source Configuration Properties]( and [Offset, Fetch & Limit]( Hope this helps!
Denodo Team
06-09-2022 19:30:55 -0400
You must sign in to add an answer. If you do not have an account, you can register here