在使用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"
);