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

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

Asked Jan 3, 2025 Modified Jan 1, 0001
Viewed 59
query

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

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

edited Jan 1, 0001
aiyuanzhi1
asked Jan 3, 2025
1 Answers

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

edited Jan 1, 1970
黄海军@SelectDB5218
answered Jan 3, 2025
Related Questions
doris查询 CATALOG hive 数据,全量查询和分区分批查询总和数据量不一致
3 answers
doris 4.0.5疑似page cache bug
2 answers
SQL Error [1105] [HY000]: errCode =2, detailMessage= type UNSUPPORTED is unsupported for Nereids
2 answers
如何通过flink cdc来实时获取doris中的数据?
1 answers
升级Doris4.1 集群 doris_cluster 发生 Critical (default) 告警
2 answers
分区表查询延迟
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 中文技术论坛.