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 <[email protected]>:
> 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. >
