You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Na Zhai <na...@kyligence.io> on 2018/11/13 13:26:03 UTC
答复: Understanding Query Cache In Apache Kylin
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<ma...@gmail.com>
发送时间: 2018年11月13日 20:50
收件人: dev@kylin.apache.org<ma...@kylin.apache.org>; user@kylin.apache.org<ma...@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
Re: Understanding Query Cache In Apache Kylin
Posted by Shrikant Bang <b....@gmail.com>.
Thank you ShaoFeng and Na Zhai for response.
Regards,
Shrikant Bang
On Tue, Nov 13, 2018, 7:51 PM ShaoFeng Shi <shaofengshi@apache.org 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: shaofeng.shi@kyligence.io
> Kyligence Inc: https://kyligence.io/
>
> Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
> Join Kylin user mail group: user-subscribe@kylin.apache.org
> Join Kylin dev mail group: dev-subscribe@kylin.apache.org
>
>
>
>
> Na Zhai <na...@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....@gmail.com>
>> *发送时间: *2018年11月13日 20:50
>> *收件人: *dev@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
>>
>>
>>
>
Re: Understanding Query Cache In Apache Kylin
Posted by ShaoFeng Shi <sh...@apache.org>.
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.shi@kyligence.io
Kyligence Inc: https://kyligence.io/
Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscribe@kylin.apache.org
Join Kylin dev mail group: dev-subscribe@kylin.apache.org
Na Zhai <na...@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....@gmail.com>
> *发送时间: *2018年11月13日 20:50
> *收件人: *dev@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
>
>
>