Latest Activity

code

Denodo doesn't push down nest function into source while caching

Hi All, I have an impala data source and I connect to it using JDBC in Denodo. While applying caching on a derived view contains a column that's an array of some other columns using nest function, I got this message in the execution plan: Denodo doesn...

Caching JDBC Nest

code

How Caching Works with Denodo?

Hi, How Denodo Cache the data when fetching it from Data Source? What's the Space it consume while caching? What's the retention period of Cache, when it flushes the Cache? Can we define the data that needs to be fully cache, partial cache or no cach...

Partial Caching Full Cache caching

code

one job in scheduler to refresh multiple views

Is there a way to have one cache job that refresh multiple views? we have a process that we had to set up 26 separate refresh jobs and I am wondering if there is a better, more efficient way of doing this?

Automic scheduler custom script caching Cache

code

Full Caching mode

Hello, I am trying out full caching mode and I am using a API from whcih I am calling data and I cannot store last refresh date in it. Can you let me know if still I can use Full caching as it fully suits my requirement.

caching

code

Caching issue while sending data to MYSQL workbench.

Hello, I have a problem with caching the data I got an error : Finished with error: Error loading cache: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Loading local data is disabled; this must be enabled on both the client and server sid...

caching

code

Centralized Caching Server

Hi Denodo Team, I have to achieve scalability with Denodo instances. If i introduce a load balancer and configure multiple denodo instances behind it. Is there a possibility that all the instances write to a single cache server via JDBC? Can i use a...

caching

code

Incremental refresh of cache

How can we Incremental reresh the cache when in SQL source we dont have created or updated timestamps, to be used in where clause.

cache performance caching

code

Caching denodo platform

Hi, Can anyone provide a hardware requirements to use oracle as a cache in denodo platform. I want to know how much space it may require and whether it will use hard disk or RAM. and so on.

caching

code

deleting cached records

How do I physically remove invalidated cached records for a view ? While 'cache_invalidate' = 'true' clause making the logical deletion, what command performs the physical deletion at view level ? Arif Zaman

caching

code

implementing caching

How do I implement caching using derby database for denodo express ? Caching configuration tab does not have any option to enter derby database details. Arif Zaman

caching