查询数据缺失问题

Viewed 35

在使用doris2.1.6版本的unique模型创建单表,当程序或者手工单条插入数据时,可查出数据,偶尔会出现过一天或者几天后查不到对应数据的情况
表的DDL如下:
CREATE TABLE load_table (
table_id int NULL COMMENT '',
sign_in varchar(255) NULL COMMENT '',
sign_in_time datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '',
sign_use_time datetime NULL COMMENT '',
sign_use_status int NULL DEFAULT "1" COMMENT '',
clndr_dt_id varchar(32) NULL
) ENGINE=OLAP
UNIQUE KEY(table_id, sign_in)
COMMENT ''
DISTRIBUTED BY HASH(table_id) BUCKETS 1
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" = "V1",
"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"
);

1 Answers

主动丢数据这个不应该的,一般情况下如果非用户主动删除数据,就只有partition过期会删数据了,这种一段时间数据丢失的情况之前没出现过。您这个case能复现吗?

可以私聊我主页微信,我们看下