Re: Question Regrading Cube Query Time

Hi All, Thanks for replying. The problem has been resolved, queries are running in sub second now. Actually, i was using dimensions as "derived" instead of "normal". Thanks On Sunday, 19 March 2017 12:29 AM, Alberto Ramón wrote: Hi can you try to rebuild

Re: Question Regrading Cube Query Time

Hi can you try to rebuild cube with a new measure? TopN 2017-03-17 17:58 GMT+00:00 Li Yang : > You didn't mention the Kylin version. Seems to be 1.6 from the > configuration property. > > The properties related to region number are (note names are slightly > differently in

Re: Question Regrading Cube Query Time

You didn't mention the Kylin version. Seems to be 1.6 from the configuration property. The properties related to region number are (note names are slightly differently in 1.6): kylin.storage.hbase.region-cut-gb=5 kylin.storage.hbase.min-region-count=1

Question Regrading Cube Query Time

Hello, I am doing a POC on kylin Cubes, I have built a Cube on TPC-DS data (~40GB). The build was successful, but i am facing issues with queries. Simple aggregation queries are returning results in sub seconds, but queries with order by/group by taking too much time. In first place, queries