CREATE TABLE dwd_table (
user_id bigint(20) ,
id bigint(20) ,
spm text
) ENGINE=OLAP
UNIQUE KEY(user_id, id)
COMMENT '用户埋点'
DISTRIBUTED BY HASH(user_id) BUCKETS AUTO
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"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"
);
我们创建表的时候错误的配置了 BUCKETS AUTO , 导致有1个tablet特别大!
现在想治理它怎么弄?单表大概1T ,帮忙看看!
x2doris , 重新创建表后写入数据。尝试后表太大,失败。