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
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