Q&A BY TAG 'cache'

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

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


Truncate and Drop Data Movement tables from Cache database
answered 13-07-2018 04:37:13 -0400

Hello, How do I remove (Truncate then Drop) the Data Movement tables that have been created in the Cache database? These tables were created - in my example, MySQL - when I had clicked on the Data Movenment option in the Derived View Execution Plan. I...

Answers: 1

data movement tables Cache

Partial Cache not working
answered 12-06-2018 09:20:31 -0400

I have created a derived view ('client') on the top of a Excel and partial cache mode is on. Now I am trying to check how partial cache works.Initially I have around 10 rows. I have also created a base view on the top of cache database. I am executing ...

Answers: 2

Partial cache with different where conditions Cache

Is it possible to query only the data in the Cache of a derived view?
answered 06-04-2018 08:15:25 -0400

Hello - very new to Denodo and running into a questions I am looking for help with. Esentially, I have created an ODBC connection between our denodo databases and Alteryx. I am querying data from a denodo table, but I am only interested in returning da...

Answers: 1

Driver ODBC Alteryx Cache

answered 09-03-2018 07:56:04 -0500

Hi: I'm trying to use fullcache for a DV compound of a join between a ODBC and JDBC base views, when executing this DV dv_customer_calls without cache the result is 2512 rows, however when updating the DV to Full Cache it restuns 0 rows. Is this the ex...

Answers: 1


Error loading cache timeout after 900seconds
answered 02-01-2018 12:47:17 -0500

Dear all when executing the cache preload VQL command SELECT * FROM "DV_ITSR.T_COSTING_RESULT_J_BV_EAGLE_MAINDB_PROD_SRZMGE_1" CONTEXT( 'cache_preload' = 'true' , 'cache_invalidate' = 'all_rows' , 'cache_wait_for_load' = 'true' , 'cache_return_quer...

Answers: 2

cache query error timeout

Identifying if Cache Maintenance is running
answered 18-12-2017 08:19:41 -0500

I'm going through the process of removing the Cache Maintenance task and replacing with scheduled clean cache calls. Is there a way that I can tell if the current Cache Maintenance task is running? Can I tell when? Since its only configured with time i...

Answers: 1