Hi,
I tried the same and it worked for me. The issue might be because the cache database might not be fully loaded with the resultset.
Please follow the below steps.
1. Create a derived view.
2. Enable partial cache and select the explicit load option.
3. Execute the view with Context clause with the following parameters in the context clause:
* ‘cache_preload’ = ‘true’
* 'cache_wait_for_load'='true'
Keep in mind that the parameter 'cache_wait_for_load' = 'true' to the CONTEXT clause forces the query to wait until all the results have been stored in the cache database. If your query returns a lot of information and you execute it again before all rows are inserted in the cache, the query will return the data from the data sources instead of from the cache.
To know more about the partial mode of cache read the section [“Partial Mode“](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/cache_module/cache_modes/partial_mode#partial-mode) and [“Recommended Parameters for Queries that Load the Cache”](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/cache_module/cache_modes/recommended_parameters_for_queries_that_load_the_cache#recommended-parameters-for-queries-that-load-the-cache) of the Virtual DataPort Administration Guide.
Hope this helps.
