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 ?