Latest Activity

code

VQL Query to Cache view - is there an include all rows command

For the VQL statement to cache view1 below, if this query is executed in a query window and the checkbox to "Retrieve all rows" is not selected, the query will cache only the number of records listed in "Limit displayed rows:" SELECT * FROM view1 CONT...

VQL CACHE

code

Reload Cache after changing BaseView with Full Cache or after Deployment

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

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

Cache DB selection between SQL server and Netezza

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?

Cache

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

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