SELECT * FROM xxx WHERE city REGEXP ('^香港|^澳门')
ERROR 1105 (HY000): errCode = 2, detailMessage = (xxxx)[INTERNAL_ERROR]UDF ERROR: hs_compile regex pattern error
SELECT * FROM xxx WHERE city REGEXP ('^香港')
可正常查询
SELECT * FROM xxx WHERE city REGEXP ('^香港|^澳门')
ERROR 1105 (HY000): errCode = 2, detailMessage = (xxxx)[INTERNAL_ERROR]UDF ERROR: hs_compile regex pattern error
SELECT * FROM xxx WHERE city REGEXP ('^香港')
可正常查询
CREATE TABLE test
(
id
int NULL DEFAULT "0",
city
varchar(50) NOT NULL DEFAULT ""
) ENGINE=OLAP
UNIQUE KEY(id
)
DISTRIBUTED BY HASH(id
) BUCKETS AUTO
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"
);
请问你们是用的平台是arm么?
Update:
https://github.com/apache/doris/pull/44547
这个 pr 可以 fix 上面的问题。
楼主,你这里报错应该是那个'|' 的问题,你可能用的是中文的'|',换英文输入法的'|'应该就好了。