Hi Phong, Kylin cache query results in two scenarios:
1) the query time exceeds 2 seconds (defined by kylin.query.cache-threshold-duration=2000) or 2) the query scan lager than 10 thousands rows in hbase (defined by kylin.query.cache-threshold-scan-count=10240) This means, the very fast and small query will not be hit by cache. You can give smaller values to the above parameters to use cache more frequently. 2017-01-10 9:03 GMT+08:00 Phong Pham <[email protected]>: > How can i turn on cache for queries? > > I turn on *kylin.query.cache.enabled=true and enabled on System tab. * > However when i query and submit query again. Result still is: > > Accept Partial: true > Is Partial Result: false > Hit Exception Cache: false > Storage cache used: false > > Kylin Version: 1.6.2 > Thanks for your help. > > 2017-01-09 20:36 GMT+07:00 Billy Liu <[email protected]>: > >> *Hit Exception Cache: false *means your query does not hit not cache, >> if you query again, the result would be "Hit Exception Cache: true" >> >> 2017-01-09 17:20 GMT+08:00 Phong Pham <[email protected]>: >> >>> Hi, >>> i saw this on log file after a query finished: >>> >>> *Accept Partial: true* >>> *Is Partial Result: false* >>> *Hit Exception Cache: false* >>> *Storage cache used: false* >>> *Message: null* >>> >>> On setting, i set: >>> *kylin.query.cache.enabled=true* >>> >>> and enable cache on System tab. >>> >>> So Is my query not cached? >>> >>> And sometime, my kylin server go down with some bad query or unknow >>> reasons. So how can i kill slow queries automatically? >>> Thanks >>> >> >> > -- Best regards, Shaofeng Shi 史少锋
