版本:2.0.12
表模型agg,第2张表有1个bitmap类型字段(其它字段和第1张表都一样),通过show data命令发现表2大小比表1多出近180G,这个是正常的吗?
CREATE TABLE `xxx1` (
`pt` date ,
`code` VARCHAR(30),
`order_id` BIGINT,
`idea_id` BIGINT,
`hour` TINYINT,
`use_area` TINYINT,
`order_source` VARCHAR(50),
`play_dur` BIGINT SUM DEFAULT "0",
`play_cnt` BIGINT SUM DEFAULT "0",
`click_cnt` BIGINT SUM DEFAULT "0"
) ENGINE = OLAP
AGGREGATE KEY(`pt`,`code`,`order_id`,`idea_id`,`hour`,`use_area`,`order_source`)
PARTITION BY RANGE(`pt`)()
DISTRIBUTED BY HASH(`order_id`, `code`) BUCKETS 8 xxx;
数据量
CREATE TABLE `xxx2` (
`pt` date ,
`code` VARCHAR(30),
`order_id` BIGINT,
`idea_id` BIGINT,
`hour` TINYINT,
`use_area` TINYINT,
`order_source` VARCHAR(50),
`point_id` BITMAP BITMAP_UNION,
`play_dur` BIGINT SUM DEFAULT "0",
`play_cnt` BIGINT SUM DEFAULT "0",
`click_cnt` BIGINT SUM DEFAULT "0"
) ENGINE = OLAP
AGGREGATE KEY(`pt`,`code`,`order_id`,`idea_id`,`hour`,`use_area`,`order_source`)
PARTITION BY RANGE(`pt`)()
DISTRIBUTED BY HASH(`order_id`) BUCKETS 16 xxx;
数据量