版本为Doris 4.0.2
#建表语句
CREATE TABLE jck.gy_dm_jdxz_new (
xzqhdm char(12) NOT NULL COMMENT "行政区划代码",
xzqhmc varchar(90) NOT NULL COMMENT "行政区划名称",
sjxzqhdm char(6) NULL COMMENT "上级行政区划代码",
zxsx int NULL COMMENT "展现顺序",
jd varchar(90) NULL COMMENT "经度",
wd varchar(90) NULL COMMENT "维度",
yxbz char(1) NULL COMMENT "有效标志",
INDEX idx_xzqhmc_inverted (xzqhmc) USING INVERTED,
INDEX idx_jd_inverted (jd) USING INVERTED,
INDEX idx_wd_inverted (wd) USING INVERTED
) ENGINE=OLAP
UNIQUE KEY(xzqhdm, xzqhmc, sjxzqhdm)
DISTRIBUTED BY HASH(xzqhdm) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"min_load_replica_num" = "-1",
"bloom_filter_columns" = "xzqhdm, sjxzqhdm, yxbz",
"is_being_synced" = "false",
"storage_medium" = "ssd",
"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"
);
#错误信息
1105 - errCode = 2, detailMessage = Failed to find enough backend, please check the replication num,replication tag and storage medium and avail capacity of backends or maybe all be on same host. Backends details: backends with tag {"location" : "default"} is [[backendId=1766713064426, host=172.20.0.3, hdd disks count={ok=1,}, ssd disk count={}]],
Create failed replications:
replication tag: {"location" : "default"}, replication num: 1, storage medium: SSD
时间: 0.048s
