Q&A BY TAG 'Cache'

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

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

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

FULL 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

Cache

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

CALL CLEAN_CACHE_DATABASE Cache

Cache settings error.
answered 24-11-2017 07:30:21 -0500

Hi guys, new issue has been found regarding cache: because of unknown reasons Denodo cannot correctly enable caching on server (Server Configuration -> Cache) with error below after applying settings: Operation completed with errors: Error sav...

Answers: 1

Cache Cache error

Cache bulk load onto sql server using bcp is failing with bcp error
answered 20-09-2017 03:42:45 -0400

I'm trying to do a bulkload cache, and facing the below error. If run manually the bcp command we can put a file to write the errors during execution. But since this is triggered by Denodo how do catch the errors during bcp execution. Below is the erro...

Answers: 4

bulkload error bcp Cache

Mismatch between source table count and cache table count
answered 12-09-2017 09:22:39 -0400

My source table has 6239797 rows and when applied full cache and did a pre cache load I could see row count as 6239794, 3 records are missing. There were no search conditions used. What could be the possibility of count mismatch ? I have ran the denodo...

Answers: 1

Cache