【routine load导入】routine load导入复杂json

sr 2.5版本,用routine load导入复杂json总是不行,请问这种嵌套的json该怎么配置?
应该是jsonpath配置不对

json样例:
{
“reason”: “suc”,
“error_code”: 0,
“result”: {
“duration”: “”,
“matchs”: [
{
“date”: “2024-10-28”,
“week”: “aa”,
“list”: [
{
“status”: “3”,
“AA”: “114”,
“BB”: “03:30”,
},
{
“status”: “3”,
“AA”: “115”,
“BB”: “06:00”,
}
]
},
{
“date”: “2024-10-29”,
“week”: “周二”,
“list”: [
{
“status”: “3”,
“AA”: “119”,
“BB”: “07:00”
},
{
“status”: “3”,
“AA”: “125”,
“BB”: “07:30”
}
]
}
],
“title”: “test”
}
}

我的routine load配置
PROPERTIES
(
“desired_concurrent_number”=“1”,
“format” = “json”,
“jsonpaths” = “[
‘$.result.matchs[].date’,
'$.result.matchs[
].week’,
‘$.result.matchs[].list[].status’,
‘$.result.matchs[].list[].AA’,
‘$.result.matchs[].list[].BB’,
]”,
“json_root” = “$.result.matchs[].list[]”,
“strip_outer_array” = “true”
)

运行报错Attempted to access an element of a JSON array that is beyond its length., msg: failed to access array field: matchs, index: -2

这个应该修复的, by this pr: https://github.com/StarRocks/starrocks/pull/19358

你用的具体是2.5哪个版本,可以升级到最新版本看看。

哦,也有可能是jsonpath不对,需要加个match[*]?

加了没用啊?这种该怎么写?