3.0.2 regexp 函数查询错误 hs_compile regex pattern error

Viewed 71
3.0

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 ('^香港')
可正常查询

fzfwqj1
5 Answers

方便提供下建表语句吗？ 我们来复现下看看

徐振超@SelectDB6541

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"
);

fzfwqj1

空表执行查询语句正常，只要插入数据后再查询，就会报错
Doris version doris-3.0.2-rc03-c21b9f5bce

fzfwqj1

请问你们是用的平台是arm么？

Update:
https://github.com/apache/doris/pull/44547

这个 pr 可以 fix 上面的问题。

楼主，你这里报错应该是那个'|' 的问题，你可能用的是中文的'｜'，换英文输入法的'|'应该就好了。

zhiqiang51