You can translate the question and the replies:

Looking for cleaning cache of specific views/folders and not whole database Using Scheduler.

CALL CLEAN_CACHE_DATABASE is cleaning whole database cache. is there any way/function to clean cache of specific views/folders and not whole database using Scheduler?
user
08-09-2016 03:16:27 -0400
code

2 Answers

Hi there, You can certainly do that. Make a new job of type VPDCache in the Scheduler, and under the Extraction section you can specify the view whose cache you would like to invalidate and set other options. Check out the section "VDPCache Extraction Section" of the Scheduler Administration Guide for more information. Also, just so you know, CLEAN_CACHE_DATABASE calls the CACHE MAINTENANCE TASK, which is described in the VDP Admin Guide. Hope this helps!
Denodo Team
09-09-2016 03:38:29 -0400
code
I'd like to clarify a few things. Cleaning a cache means to remove all rows that are invalid or expired. Invalidating a cache makes rows invalid so that they will not be returned when querying the view. Using a VDPCache job will cause data to be reloaded. If you just want to invalidate some rows or a specific view, then you could use an ALTER statement like: ALTER VIEW <your view> CACHE INVALIDATE or ALTER VIEW <your view> CACHE INVALIDATE ON CASCADE if you wanted to invalidate the data in underlying views' caches. Finally, for the CLEAN_CACHE_DATABASE stored procedure it will clean (delete invalid rows) from the cache for all tables cached in that database.
Denodo Team
09-09-2016 06:51:38 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here