Hi all, Currently I am using Kylin 1.6.1 and I face a problem about cube building time. I have one fact table and two lookup tables. When I set 13 normal dimensions and 15 derived dimensions and two measures (count and count distinct). The step3 in building takes around 20mins and the entire building takes around 1 hour. This is good. However, when I try to increase to 15 normal dimensions and 15 derived dimensions and two measures(count and count distinct). The step3 in building takes around 240mins and the entire building takes forever…. BTW, I have a hierarchy dimension which has 4 normal dimensions. I am really confusing about this. Does 13 normal dimensions become a bottleneck in building cube?
Thanks a lot! Zhuoran
