Q&A BY TAG 'Cache'

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

Partial cached data subset still going to source
answered 14-05-2019 18:48:27 -0400

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

Answers: 1

Partial cache Cache

Schema change and Source Refresh with Denodo and Cache store
answered 24-04-2019 17:23:09 -0400

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

Answers: 1

Source refresh schema change Cache Cache error

Why is it recommended that Apache Derby embedded database should NOT be used for storing cache data for production?
answered 15-04-2019 14:17:44 -0400

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

Answers: 1

Cache

Cache Error Modifying View
answered 05-03-2019 06:48:57 -0500

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

Answers: 2

Cache

SSRS and Caching
answered 27-02-2019 05:02:03 -0500

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

Answers: 1

cache partial cache ssrs

Cache modes
answered 07-01-2019 17:56:38 -0500

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

Answers: 1

Partial cache Cache

Cach data using Java
answered 18-12-2018 07:48:12 -0500

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

Answers: 2

java Cache

Power Query parameters not working when cache is on
answered 14-12-2018 13:01:38 -0500

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?

Answers: 1

Power BI Cache

VDP "store results in cache" isn't working
answered 05-11-2018 11:23:16 -0500

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

Answers: 1

Cache

cache refresh info
answered 07-08-2018 02:22:08 -0400

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?

Answers: 1

VQL VDP Cache