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

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

Asked May 28 Modified Jan 1, 0001
Viewed 27
3.0

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

WHERE 
array_contains(tags, 101) OR 
array_contains(tags, 205) OR 
array_contains(tags, 310)
edited Jan 1, 0001
Da Wan15
asked May 28
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
徐振超@SelectDB7446
answered May 30
Related Questions
Doris部署架构推荐
1 answers
doris3.0.5版本,执行查询和插入时候数据量不一致
1 answers
通过enable_audit_plugin开启审计日志,audit_log表创建了但是没有数据
1 answers
Doris 3.0.7 存算分离FE内存泄露问题
1 answers
随便插入一条数据be就挂掉了,数据也无法正常插入
1 answers
Doris一直循环报错DATA_QUALITY_ERROR,应该如何定位和解决这个问题
1 answers

Terms of service Privacy policy

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