selectdb 如何查询json数据是否含有某个数组

Viewed 31
query

["SD00000003","SD00000002","SD00000017","SD00000021","SD00000028","SD00000020","SD00000071"]

如上数组格式，如果通过sql查询里边是否包含某个数组

1 Answers

看看array_contains函数和json_contains函数是否满足你的需求

黄海军@SelectDB5188
Related Questions
Doris 3.1 查询加速
Doris的Arrow Flight SQL功能，CN应该如何配置
Doris 3.1 manager webui查询
1 answers
表锁超时 Caused by: java.sql.SQLException: errCode = 2, detailMessage = get tableList write lock timeout
1 answers
2.0.2版本同步物化视图不生效
Doris 1.2.8 查询嵌套视图数据时，报错IllegalArgumentException
1 answers