Latest Activity

code

Need help on incremental caching

Being new to Denodo , need help to implement the below situation. INVOLVED TABLES -------------------------- Customers table is static. Orders table is incremental. VIEW DEFINITION ----------------- CREATE VIEW customers_j_orders AS SELECT customer...

cache

code

Error on Cache mode enable for Partial or Full on base view

In trying to activate the cache for a base view which was created from a query, it throws up an error dialog in either trying to activate partial or full cache on the base view. Error for partial cache activation is: "error modifying view: An SQL data...

cache

code

Derby Cache Exception in Log and no Cache results returning

Created a base view which has custom sql to create it that comes back with two text columns. Both vase view and original database have those columns set as varchar(1024). When executing the base view with cache invalidate it returns rows back. When ...

cache derby

code

Full cache, changing settings, redeploying VQL code seems to cause the existing cache to be invalidated?

I have a view, 'person_cache', that is configured to have a "Full" cache and a TTL of 86400 (1 day). I have a batch job that invalidates the existing cache and loads it once every hour. I wanted to change the TTL to two weeks ( 1209600 ) and change m...

cache

code

Join to a cached view twice, but only fetch once

I have view emp (jdbc) and view ad (LDAP). AD is a partially cached view. We join emp.id to ad.id and it works great. Now I need to also join emp.supervisor_id to ad.id to get the supervisor information. When I look at the execution trace, it app...

cache VDP