Hello all,
I am running the 0.7.1-incubating, installed from the release binary.
Currently, repeated executions of certain queries result in cache hits (as
I expected)
Example:
If I execute twice this query, I get results served from cache the second
time ("hitCache": true):
SELECT column_1, column_2
FROM FACT_TABLE
INNER JOIN DIMENSION_TABLE on FACT_TABLE.id = DIMENSION_TABLE.id
WHERE date_ < date'2014-08-31'
GROUP BY column_1, column_2
On the other hand, repeated execution of the query below never lead to
cache hits (i.e. I always end up with "hitCache": false).
SELECT count(*) as total_count
FROM FACT_TABLE
WHERE date_ < date'2014-08-31'
My use case would highly benefit from extensive caching, since I have few
heavy repeated queries to issue to the system.
I am not familiar with current Kylin cache strategy, and I was wondering if
someone could give me some hints.
Besides, I have not found any cache-related parameter in property files,
aside from kylin.query.cache.enabled in conf/kylin.properties
(kylin.query.cache.enabled is set to true in my case)
Thanks
luca
