OK, I found the answer: high cardinality dim first. ________________________________ 发件人: Shiao Gabriel <[email protected]> 发送时间: 2020年12月31日 2:46 收件人: [email protected] <[email protected]> 主题: When adjust rowkey order, for dim used by 'GROUP BY', should it be the front of rowkey?
Hi, I bought the book "Apache Kylin 权威指南"， in the page 56 for adjusting rowkey order rules, it said： 对于不会出现在过滤条件的维度，按照基数高低，优先将低基数维度放在rowkey的后面。(I tried to translate: For the dimenstion which wont be in where condition, based on the cardinality, the dimension which has lower cadinality shoud be in the back of rowkey). I am confused by the word "后面”（translate as "back"), this type of deminsion should be in the left side or right side of rowkey? such as d1(cardinality 5), d2(cardinality 100), in rowkey order: it should be d1d2, or d2d1? Thanks.
