Apache Doris 中文技术论坛
Questions Tags Users Badges

求一个查询一个数组字段包另一个数组中任意值的语法

Asked May 28, 2025 Modified Jan 1, 0001
Viewed 30
3.0

一个数组字段包含另外一个数组中的任意一个值,就像下面这种查询,有更简洁的语法吗

WHERE 
array_contains(tags, 101) OR 
array_contains(tags, 205) OR 
array_contains(tags, 310)
edited Jan 1, 0001
Da Wan25
asked May 28, 2025
1 Answers

可以看下这个arrays_overlap
https://doris.apache.org/zh-CN/docs/3.0/sql-manual/sql-functions/scalar-functions/array-functions/arrays-overlap

edited Jan 1, 1970
徐振超@SelectDB8151
answered May 30, 2025
Related Questions
doris2.1.5升级到doris3.0.8,升级后开启ranger,root执行SHOW PROC '/backends' 报没有admin权限
routine load只支持部分列更新,不支持灵活列更新,什么时候能支持?
1 answers
为什么采用AGGREGATE KEY引擎的REPLACE_IF_NOT_NULL,最后的查询巨慢?
1 answers
Spark Doris Connector 写入 doris 云服务器内网不可达
1 answers
存算分离创建 STORAGE VAULT 问题,hdfs高可用下dfs.client.failover.proxy.provider.mycluster配置问题
1 answers
the report queue size exceeds the limit: xxx
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2026 Apache Doris 中文技术论坛.