Latest Activity
Hi Denodo Community, One Question from the new guy here :-) After Changing a Base View with "Source Refresh" the Cache Table is new generated. After that the Cache Table is empty. Now i have to remember to fill the Cache Table with "Starting the Sche...
Hi I have a view partially cached without 'Explicit loads' and without 'Match exact queries only' and TTL = 60. In another view, I am calling the former more than once, but the cache is not built and Denodo goes to the data source all the times!? (runt...
I want to enable cache, but I am curious to know which one is best for use from SQL Server and Netezza? Can you provide a comparison sheet or you can help me to understand between them as which is one benificial to use?
For almost all of the Denodo articles that talk about caching, we see snippets like this: "... you can configure the cache module to store the cache data in the Apache Derby database embedded in Virtual DataPort. However, we strongly recommend using an...
The Denodo Platform cache can be used to for what do we use the denodo platform cache ? and why do we cache data ? is it for avoiding running the same queries again or whaen the data is geographically distributed?
Hello, We have a VDB with cache db configured on Azure PostgreSQL v11. Assume a scenario when a SELECT is already running on Denodo VDB, accessing data from the configured cache. Now, if the Cache refresh job starts, at a set time, through Denodo Sched...
Hi, Is there a VQL query I can run as a developer in Denodo to determine the time to live of cached views? I have tried the following queries but it seems to only indicate whether the item is cached or not. select from catalog_views() where resultcac...
in denodo scheduler the cache jobs are stuck running state
Team, Executing a cache job to replicate data from Oracle to Redshift using the bulk data load API option for Amazon Redshift. Most of the tables are loading but couple of them are failing without much error details. 25276858 [Full_cache_u_fixture_18...
Hi, I am following the tutorials for denodo platform, it all went well until the cache settings from here: https://community.denodo.com/tutorials/browse/basics/5cache2view I have configured cache settings in server configuration by choosing "embedde...