You can translate the question and the replies:

create_datetime >= '@LAST_REFRESH_DATE' in incremental cache not delegated to the source

I created a baseview over a cTree Datasource. I then enabled full cache, which works fine. Finally, I would like to enable incremental caching. I set the condition to create_datetime >= '@LAST_REFRESH_DATE' When I run a query, the execution trace shows, that the data is gathered from the cache, as well as from the original source. However, the condition create_datetime >= '@LAST_REFRESH_DATE' is not pushed down to the source, but the complete data is loaded, and the filtered within the vdp. If I add another where statement to the query, like "create_datetime >= now()", this one is correctly pushed to the source. So what could be the reason, that the condition for incremental caching is not pushed down?
Incremental Cache Delegate pushdown
user
27-09-2022 11:45:01 -0400
code

1 Answer

Hi, I think If your view completely meets all the requirements for the incremental mode, then your condition is supposed to be delegated to the data source of the view. So I recommend you review if your view meets the requirements for the incremental cache mode. You can read through the [Requirements a View Has to Meet to Support Incremental Queries](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/cache_module/cache_modes/incremental_mode#requirements-a-view-has-to-meet-to-support-incremental-queries) section of the Virtual DataPort Administration Guide. If you need more help and have a valid support account, you can open a new case in the Support Site so the Denodo team can help you. Hope this helps!
Denodo Team
28-09-2022 05:59:32 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here