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: shaofeng....@kyligence.io Kyligence Inc: https://kyligence.io/ Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: user-subscr...@kylin.apache.org Join Kylin dev mail group: dev-subscr...@kylin.apache.org Na Zhai <na.z...@kyligence.io> 于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 <b.shrikan...@gmail.com> > *发送时间: *2018年11月13日 20:50 > *收件人: *d...@kylin.apache.org; user@kylin.apache.org > *主题: *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 > > >
