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

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

Asked Jan 3, 2025 Modified Jan 1, 0001
Viewed 40
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
Doris4.0.2版本,集群部署模式3台主机,不稳定,经常报错。insert报failed to write enough replicas 0/1 for tablet,select查询也报错
1 answers
倒排索引match返回结果不正确
1 answers
[Bug] Arrow Flight SQL 在大数据量下出现 StringArray 偏移量损坏与内存越界
Doris无法查询information_schema.tables表信息
1 answers
flink-doris-connector-1.20.24.0.0 2pc ,checkpoint处恢复数据重复
1 answers
odbc从doris4.0读取含有emoji表情符号时异常
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 中文技术论坛.