Latest Activity

code

Why is it recommended that Apache Derby embedded database should NOT be used for storing cache data for production?

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...

Cache

code

Partial cache without explicit load

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...

Cache

code

The Denodo Platform cache

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?

Cache

code

Denodo Cache refresh gets stuck when a SELECT is already being executed on the VDB

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...

Cache Error Cache

code

Is there a VQL query I can run as a developer in Denodo to determine the time to live of cached views?

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...

Cache

code

in denodo scheduler the cache jobs are stuck running state

in denodo scheduler the cache jobs are stuck running state

Cache

code

Denodo Cache job error

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...

Cache scheduler job

code

Cache not working

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...

cache

code

Cache job status related

Hi Team, We are doing full cache on final view,which is created using 5 views with join and union but it is getting successfull even after one of the dependend view having connectivity issue.

Cache

code

About cache

I have a question about caching. I couldn't understand it by looking at the document, so could you please tell me a little more concisely and clearly? 1) What is Partial mode? 2) When "Explicit loads" is turned on and off 3) When "Match exact querie...

Partial cache Cache