Latest Activity

code

cache refresh info

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?

VQL VDP Cache

code

Truncate and Drop Data Movement tables from Cache database

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

data movement tables Cache

code

Partial Cache not working

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

Partial cache with different where conditions Cache

code

Is it possible to query only the data in the Cache of a derived view?

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

Driver ODBC Alteryx Cache

code

FULL CACHE

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

Cache

code

Error loading cache timeout after 900seconds

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

cache query error timeout

code

Identifying if Cache Maintenance is running

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

CALL CLEAN_CACHE_DATABASE Cache

code

Cache settings error.

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

Cache Cache error

code

Cache bulk load onto sql server using bcp is failing with bcp error

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

bulkload error bcp Cache

code

Mismatch between source table count and cache table count

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

Cache