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?
27-09-2022 11:45:01 -0400

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]( 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
You must sign in to add an answer. If you do not have an account, you can register here