Doris的json解析问题

Viewed 4

数据示例:
[{"categoryId":1000,"categoryName":"鸡","categoryDes":"使用对象"},{"categoryId":1003,"categoryName":"蛋鸡","categoryDes":"品种"},{"categoryId":1006,"categoryName":"育雏期","categoryDes":"生长周期"},{"categoryId":1012,"categoryName":"5%","categoryDes":"百分比"},{"categoryId":2,"categoryName":"包","categoryDes":"销售单位"},{"categoryId":1015,"categoryName":"25kg","categoryDes":"净含量"}]
数据类型:product_specific varchar(65533)
查询sql:
SELECT json_extract(product_specific, '$.categoryId'),product_specific FROM ods_product_goods_full
返回结果:
[1000,1003,1006,1012,2,1015]
这个在doris2.0.2版本可以查询,在doris2.1.11版本查询结果为null

0 Answers