this link might be helpful: http://www.slideshare.net/YangLi43/design-cube-in-apache-kylin?qid=145080e7-4abe-42c9-8048-f29ffec8a66c&v=default&b=&from_search=10
On Wed, May 27, 2015 at 4:17 PM, Luke Han <[email protected]> wrote: > Forward to mailing list for further support. > > Thanks. > > 在 2015年5月27日星期三 UTC+8下午4:11:09，Puneet Gupta写道： >> >> Hi , >> >> Is there any log message that i can look for to determine the exact >> number of cuboids ( dimension combination) that will be generated . >> >> >> I have a small Fact table with 10,000 rows . The number of dimensions are >> 11. >> When I arrange the dimensions such that 2 are of type "column" and 9 are >> of type "derived" and I choose cube size ="small" in GUI , i get close to >> 830,000 rows in HBase Aggregate/Cuboids table. >> >> When I arrange the dimensions such that 2 are of type "Hierarchy" >> (Hierarchy1 has 4 levels Year,month,day,hour and Hirerachy2 has 2 levels >> Protocol Category and Protocol), 2 are of type "column" and rest are of >> type "derived" and I choose cube size ="small" in GUI , i get close to >> 2,000,000 rows in HBase Aggregate/Cuboids table. >> >> In both cases i selected Dictionary compression for row keys >> >> I wanted to control how many aggregates get generated. I feel the size >> of aggregate table is too high . >> >> Any suggestions ? > > -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
