Thank you ShaoFeng and Na Zhai for response. Regards, Shrikant Bang
On Tue, Nov 13, 2018, 7:51 PM ShaoFeng Shi <[email protected] wrote: > Kylin's query cache is simple, just checking the SQL's signature; so, in > your case, the query of (D1, D2) won't use the cache of (D1, D2, D3). > > > Best regards, > > Shaofeng Shi 史少锋 > Apache Kylin PMC > Work email: [email protected] > Kyligence Inc: https://kyligence.io/ > > Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html > Join Kylin user mail group: [email protected] > Join Kylin dev mail group: [email protected] > > > > > Na Zhai <[email protected]> 于2018年11月13日周二 下午9:26写道： > >> Hi, Shrikant Bang >> >> I think it will not go through query cached result(of D1,D2,D3) . >> >> >> >> 发送自 Windows 10 版邮件 <https://go.microsoft.com/fwlink/?LinkId=550986>应用 >> >> >> >> *发件人: *Shrikant Bang <[email protected]> >> *发送时间: *2018年11月13日 20:50 >> *收件人: *[email protected]; [email protected] >> *主题: *Understanding Query Cache In Apache Kylin >> >> >> >> Hi Team, >> >> >> >> Let say I have a cube on dimensions D1, D2, D3 and Metrics M1, M2, M3. >> >> >> >> When I hit a multiple queries on grouping dimension D1, D2, D3, it will >> get cached and cuboid will be hot. >> >> >> >> Once cuboid (D1,D2,D3) gets cached and I will hit a query on grouping >> dimension D1, D2 (with similar metrics). >> >> Will query go through query cached result (of D1,D2,D3) or runs a query >> on HBase Table? >> >> >> >> P.S. I am using Apache Kylin v2.5.1-hbase1.x >> >> >> >> Thank You, >> >> Shrikant Bang >> >> >> >
