问题
昨晚数据量139399,今早数据量122520,有定时任务每个15分钟使用insert into插入少量的数据。
用show tablets没有状态异常的副本
表结构
CREATE TABLE external_publish_channel_relation
(
content_num
varchar(50) NULL COMMENT '内容id',
channel_id
int(11) NOT NULL DEFAULT "0" COMMENT '渠道id'
) ENGINE=OLAP
UNIQUE KEY(content_num
, channel_id
)
COMMENT '发布渠道关系表'
DISTRIBUTED BY HASH(content_num
) BUCKETS 3
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"is_being_synced" = "false",
"storage_format" = "V2",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false"
);