1. Use Derived Dimension will reduce the number of rowkey, but also may hurt the query performance. 2. Increase the threshold of the HBase region size, # The cut size for hbase region, in GB. kylin.storage.hbase.region-cut-gb=5
3. Split the large cube into two small cubes according to your query patterns. 2017-09-15 14:28 GMT+08:00 谁主沉浮 <838279...@qq.com>: > We have more dimensions, and can reach more than 20, so the number of > region will be much larger, and rowkey also accounts for a lot, so how to > reduce the HBase region count? > > > ------------------ 原始邮件 ------------------ > 发件人: "Billy Liu";<billy...@apache.org>; > 发送时间: 2017年9月15日(星期五) 下午2:24 > 收件人: "dev"<dev@kylin.apache.org>; > > 主题: Re: [KYLIN-1668] - Rowkey column shouldn’t allow delete and add > > > > Rowkey is the physical format of dimensions. > > 2017-09-15 12:55 GMT+08:00 谁主沉浮 <838279...@qq.com>: > > > If you don't want to delete the dimension, how do you delete some rowkey? > > > > > > ------------------ 原始邮件 ------------------ > > 发件人: "Billy Liu";<billy...@apache.org>; > > 发送时间: 2017年9月15日(星期五) 中午12:51 > > 收件人: "dev"<dev@kylin.apache.org>; > > > > 主题: Re: [KYLIN-1668] - Rowkey column shouldn’t allow delete and add > > > > > > > > Rowkey is generated by the chosen dimensions. If you want to remove some > > rowkey, remove the dimension will work. > > > > 2017-09-15 11:54 GMT+08:00 谁主沉浮 <838279...@qq.com>: > > > > > [KYLIN-1668] - Rowkey column shouldn’t allow delete and add > > > Kylin new version 2.1, this problem still exists,cannot delete > > >