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

使用Variant类型保存JSON数组,需要遍历数组对里面的字段进行统计是要怎么访问对应字段?

Asked Jan 28, 2025 Modified Jan 1, 0001
Viewed 76
3.0 2.1

如题。
[{"a": 100}, {"a", 200}]
比如我用Variant存了,然后想sum a

edited Jan 1, 0001
xiongyu3
asked Jan 28, 2025
1 Answers

image.png get_json函数

edited Jan 1, 1970
xxxl20
answered Feb 6, 2025
Related Questions
doris3.0.8 3台中一台be节点偶发性宕机
2 answers
关于数值类型decimalv3兼容性问题
2 answers
ccr任务job_progress接口-子任务的binlog_type字段都有哪些枚举值
ccr数据同步成功了,但是执行get_lag的last_binlog_timestamp和first_binlog_timestamp为什么都是1970-01-01 08:00:00,我该怎么查看上次同步时间呢
1 answers
使用doris物化视图做数仓分层,哪种策略好
1 answers
物化视图创建-使用LATERAL VIEW EXPLODE_OUTER
2 answers

Terms of service Privacy policy

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