olo123456 opened a new issue, #3318:
URL: https://github.com/apache/doris-website/issues/3318
Path:/zh-CN/docs/3.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract
数据示例：
[{"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
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
