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'.'
datacatalog
user
06-09-2022 08:56:20 -0400
code

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](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/data_source_configuration_properties/data_source_configuration_properties) and [Offset, Fetch & Limit](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/queries_select_statement/offset_fetch_and_limit/offset_fetch_and_limit). Hope this helps!
Denodo Team
06-09-2022 19:30:55 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here