我有一个 JSON 数组
'[
{"key": "cId", "value": "d03ce656"},
{"key": "cName", "value": "Healthcare"},
{"key": "pId", "value": "d869628b"},
{"key": "pName", "value": "ConveYour"}
]
我想将其转换为
{
"cId": "d03ce656",
"cName": "Healthcare",
"pId" : "d869628b",
"pName": "ConveYour"
}
到目前为止我已经尝试过
SELECT
OBJECT_CONSTRUCT(
parse_json(f.value):key::string,
parse_json(f.value):value::string
) AS json_object
FROM LATERAL FLATTEN(INPUT => PARSE_JSON('[
{"key": "cId", "value": "d03ce656"},
{"key": "cName", "value": "Healthcare"},
{"key": "pId", "value": "d869628b"},
{"key": "pName", "value": "ConveYour"}
]')) AS f;
但它给了我
JSON_OBJECT
{ "cId": "d03ce656" }
{ "cName": "Healthcare" }
{ "pId": "d869628b" }
{ "pName": "ConveYour" }
我不需要 4 行,而是一个元素 { "cId": "d03ce656", "cName": "Healthcare", "pId" : "d869628b", "pName": "ConveYour" }