Hi All, We are trying to build a nine-dimension cube: eight mandatory dimensions and one hierarchy dimension. The fact table is like 20G. Two lookup tables are 1.3M and 357k separately. It takes like 3 hours to go to 30% progress which is kind of slow.
We'd like to know are there suggestions to speed up the Kylin cube build. We got a suggestion from a slide said that sort the dimension based on the cardinality. Are there any other ways we can try? We also noticed that only half of the memory and half of the CPU are used during the cube build. Are there any ways to fully utilize the resource? Looking forward to hear from you. Best regards, Zhong
