Latest Activity
We are currently trying to use partial cache in denodo in both the versions of 6 & 7 and facing one issue. When we put the partial cache on for the view and run the query to cache it. For eg. Select * from test1 where id in (1,2,3,4); it caches ...
Hello, We have snowflake as our cache store. When we add a new column to source, our cache refresh jobs fails with "Number of columns in file (25) does not match that of the corresponding table (23),". Any process we ned to follow to update cache schem...
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...
Hi - we have been having intermittent problems with our cache. Randomly, when I try to change the cache mode on any view, I receive the error: Error modifying view: Error getting valid table name At this point, I have to ask our admin to reboot or res...
I have created an SSRS report with parameters that the user inputs (using ? as parameter in the SQL). The derived view that the SSRS report is using has partial cache mode turned on with match exact queries only selected. It seems as if the report is ...
Hi, I'm using the Denodo Express Edition platform and I'm trying to try the partial cache mode with the Match exact queries only option. I have entered Administration> Server configuration and I have activated Cache Status. Then before executing the...
--typo on header can not edit :( i want to cache data using java .i have following question 1.Denodo have any API? 2.Please share sample code? i have modifed the denodo jdbc client sample and tried it is not working. please help me on this
Hi - I have a view with 1 parameter that I am consuming in Excel through ODBC. I cannot pass the parameter back to Denodo unless the cache is turned off of the view. Is there any solutions for this?
when I execute the following SELECT FROM oneview CONTEXT ('i18n'='us_mst', 'cache_preload'='true', 'cache_wait_for_load'='true') it returns around 160 records. However, subsequently when i do select from oneview i get zero records.. why isnt my cache...
Hi Guys, is it possible to get a list of views having caching enabled, to check their latest cache refresh using VQL? If not using VQL, does Denodo have other ways to check for caching info about views?