What's kind of queries? How many records supposed to be returned? Could you send out the query log together?
2016-08-12 10:28 GMT+08:00 Mars J <[email protected]>: > Hi, > I have run Kylin 1.5.2.1 and build a cube successfully,the cube size is > 3.2G for fact table and dimensional table have 1.5 million records > seperately.HTable count is about 200 billion. > My Cube Design includes 3 Derived Dims and 5 Normal Dims which formed a > hierachy dim in agg. Rowkeys are generated automatically,the first and > second rowkey is the highest cardinality column in fact table and one dim > table seperately. > > When I query it from kylin insight, it costs 11s,and the second same > query is also 10+s, How can I optimize this ? > -- With Warm regards Yiming Liu (刘一鸣)
