应用对接需要用到__internal_schema下的系统表,发现除了audit_log表有数据,另外两张系统表column_statistics和partition_statistcs的数据大小都是0,表查询的时候报no queryable found in tablet id,请问这种情况如何处理?
应用对接需要用到__internal_schema下的系统表,发现除了audit_log表有数据,另外两张系统表column_statistics和partition_statistcs的数据大小都是0,表查询的时候报no queryable found in tablet id,请问这种情况如何处理?
CREATE TABLE column_statistics (
id varchar(4096) NOT NULL,
catalog_id varchar(1024) NOT NULL,
db_id varchar(1024) NOT NULL,
tbl_id varchar(1024) NOT NULL,
idx_id varchar(1024) NOT NULL,
col_id varchar(1024) NOT NULL,
part_id varchar(1024) NULL,
count bigint NULL,
ndv bigint NULL,
null_count bigint NULL,
min varchar(65533) NULL,
max varchar(65533) NULL,
data_size_in_bytes bigint NULL,
update_time datetime NOT NULL
) ENGINE=OLAP
UNIQUE KEY(id, catalog_id, db_id, tbl_id, idx_id, col_id, part_id)
COMMENT 'Doris internal statistics table, DO NOT MODIFY IT'
DISTRIBUTED BY HASH(id, catalog_id, db_id, tbl_id, idx_id, col_id, part_id) BUCKETS 7
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V2",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728",
"enable_mow_light_delete" = "false"
);
上面是show出来的建表语句,truncate后,加一个replication_num=3的参数重新建表是么,请问数据后续会自动重新写入么?