Q&A BY TAG 'Cache'

You must sign in to ask a question. If you do not have an account, you can register here

VQL to show all cached sources and when it was last refreshed?
answered 01-06-2021 17:37:03 -0400

Is there a way to get a result set that has the view, number of rows and the last cache refresh date? I want to make this a data set availbe easily to end-users to see when the cache was last updated. I have scoured the user documentation but do not ...

Answers: 1


CONTECT('cache'= 'off') is not fetching data from sources
answered 06-05-2021 18:15:10 -0400

Hi Team, I'm using Denodo 7.0. I have a derived view dv_join which has several intermediate views. Full cache mode is enabled for this view and Oracle is the cache DB. Loading the cache for this view is taking around 1 hour to complete. I want to s...

Answers: 1

cache context

How do I find the denodo-incremental-cache-load-{vdpversion}-{version}-jar-with-dependencies.jar file on the support site?
answered 22-12-2020 21:01:06 -0500

I know the denodo-incremental-cache-load-{vdpversion}-{version}-jar-with-dependencies.jar file is on the support website because I found another user's question that has that bit of information in it (https://community.denodo.com/answers/question/detai...

Answers: 1

Incremental Cache Cache Denodo Jar

How does Full cache work after deployment to other environments?
answered 22-12-2020 05:17:58 -0500

I have enabled a "Full" cache on a Derived view. I would like to deploy this view to Staging and Production. After importing the VQL and Properties files (deployment) in Staging and Production, do I need to manually go to "Execution Panel" -> chec...

Answers: 1


Find Cache Index Tables
answered 16-12-2020 07:17:32 -0500

Hi, Can you please advise how Cache Index Tables can be found related to a Cached View. Procedure GET_CACHE_TABLE displays information about Cache Data Tables only. Thanks. User

Answers: 1
Related to: Cache database size estimate

Cache Index Cache

Scheduling Cache Problem with Base View
answered 28-10-2020 04:03:19 -0400

Hello, My base views evertime needs a session id to fetch the data(execution). SO I have used an interpolation variable for feeding session key. Session key is generated in different table to whom I usually point when I create a derived view so ...

Answers: 1


Incremental cache for deleted rows
answered 07-10-2020 08:29:44 -0400

Hello, the following link https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Incremental%20Cache%20Load%20Stored%20Procedure%20-%20User%20Manual specifies that Notice that this Stored Procedure can only be used with views where...

Answers: 1


Where is the incremental cache jar located in the Denodo program files?
answered 02-09-2020 06:08:32 -0400

The instructions to setup an incremental cache reference the .jar denodo-incremental-cache-load-{vdpversion}-{version}-jar-with-dependencies.jar. Where is this jar located? I cannot find it anywhere in our program files for our installation of Denodo 7...

Answers: 4


How to do the cache load for a view
answered 18-08-2020 08:50:38 -0400

How to load cache load for a view, we have kinds of cacje mode, full, partial, waht is the exact command? do we have artical to introduce it? Thank you.

Answers: 1

vql cache data preload

Issues connecting to RDS mysql V8 from Denodo VDP client.
answered 31-07-2020 13:13:16 -0400

Hi Team, We use AWS RDS for Denodo Cache. We have upgraded RDS mysql version from 5.6.41 to 8.0.16. When trying to connect from Denodo VDP to RDS, it is throwing below error. Unable to establish connection: Communications link failure The last packe...

Answers: 3