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

【已解决】1.2.7升级到2.0.10,使用jsonb_extract_string函数报错Json path error

Asked May 29, 2024 Modified Jun 3, 2024
Viewed 79
2.0 upgrade

版本:2.0.10

升级后使用jsonb_extract_string函数报错
image.png

edited Jun 3, 2024
yugunsung117
asked May 29, 2024
1 Answers

1.2.7中json_path可以不指定$符号,升级之后json_path 必须以 $ 符号作为开头

SELECT
event_date,
jsonb_extract_string(extra, '$.qr_code')
FROM
fact_common_events
LIMIT
10;

edited Jan 1, 1970
yugunsung117
answered May 30, 2024
Related Questions
Doris 2.0.15,3FE、6BE(3BE mix角色 3BE computation角色)3个mix角色的BE节点CPU使用率100%
1 answers
我的doris版本为2.0.6 在备份操作时,会导致所以fe节点宕机,这种情况该怎么排查,为什么备份会导致这个问题?
1 answers
Doris Routine Load自动恢复机制
1 answers
doris fe节点变更成高可用配置
1 answers
各位大哥在通过k8s安装doris3.0的时候,有没有遇到cg启动不起来,提示Set max number of open file descriptors to a value greater than 60000.
1 answers
flink-doris-connector-1.20.24.0.0 2pc ,checkpoint处恢复数据重复
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 中文技术论坛.