Latest Activity

code

How does Full cache work after deployment to other environments?

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

Cache

code

Find Cache Index Tables

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

Related to: Cache database size estimate

Cache Index Cache

code

Scheduling Cache Problem with Base View

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

Cache

code

Incremental cache for deleted rows

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

Cache

code

Where is the incremental cache jar located in the Denodo program files?

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

Cache

code

How to do the cache load for a view

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.

vql cache data preload

code

Issues connecting to RDS mysql V8 from Denodo VDP client.

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

Cache

code

Denodo 7.0 not invalidating matching rows with dynamic VQL, working in 6.0

I have a cache update query with the paramaters: select * from view_name where "PeriodMonth" in ( cast('text',substr(FORMATDATE('MMM', ADDMONTH(CURRENT_DATE(),-1)),1,1)||lower(substr(FORMATDATE('MMM', ADDMONTH(CURRENT_DATE(),-1)),2,3))||'-'||FORMATDAT...

7.0 Cache

code

Incremental Cache Stored Procedure times out after 80 seconds

We are running the incremental cache stored procedure to insert/update records since the @LASTCACHEREFRESH. The procedure continues to fail with a generic error 'Finished with error: ERROR executing query update of cache [Rows updated in cache: 0].'. ...

Incremental Cache Cache

code

Cached view - Tableau Server will not pull in data

I have a view that I can see cached results for in the VDP. I have scheduler set to refresh this cache daily. For some reason Tableau Server will not succefully connect to this data source (it is visible in the connections list). It has ~250k rows and ...

Automic scheduler Full Cache denodo with tableau Cache