kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Billy Liu <billy...@apache.org>
Subject Re: Kylin query performance always slows in first time
Date Fri, 06 Jan 2017 08:30:45 GMT
If you repeat the same query again, it will hit the query cache I think.

2017-01-06 15:39 GMT+08:00 Hoang Le Trung <hoangletrung@orenj.com>:

> Hi team,
>
>
>
> I have faced problem about query performance on Kylin.
>
> I run two instance Kylin(job) and Kylin(query) on two node of my hadoop
> cluster.
>
>
>
> When my cluster have high load, it make kylin query running slow. I think
> high load affect to Hbase so that it make kylin read data from Hbase
> slower.
>
> But
>
> When my cluster have normal load (average below 10% CPU). I login Kylin
> and test one query, It always slow on first time. When I repeat this query
> again, I see it’s faster.
>
> I test with a lot of queries, but it’s always slow on 1st try.
>
>
>
> I wonder Do Kylin have slower when open connection and faster after that ?
>
>
>
> If not So any solution to fix my issue?
>
>
>
>
>
>
>
>
>
> Thanks!
>
>
>
> ------------------------------
> This e-mail may contain confidential or privileged information. If you
> received this e-mail by mistake, please don't forward it to anyone else,
> please erase it from your device and let me know so I don't do it again.
>

Mime
View raw message