You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-zh@flink.apache.org by "junjie.miao@goupwith.com" <ju...@goupwith.com> on 2023/11/23 07:24:33 UTC
回复: flink sql如何实现json字符数据解析?
可以看下JSON函数
https://nightlies.apache.org/flink/flink-docs-release-1.18/docs/dev/table/functions/systemfunctions/#json-functions
Junjie.M
发件人: casel.chen
发送时间: 2023-11-22 20:54
收件人: user-zh@flink.apache.org
主题: flink sql如何实现json字符数据解析?
输入:
{
"uuid":"XXXX",
"body_data": "[{\"fild1\":1"1231","fild2\":1"2341"},{"fild1\":"abc\","fild2\":"cdf\"}]"
}
输出:
[
{
"uuid": "XXXX",
"body_data: null,
"body_data.fild1": "123”,
"body_data.fild2": "234"
},
{
"uuid": "XXXX",
"body_data": null,
"body_data.fild1": "abc",
"body_data.fild2": "cdf"
}
]
当格式错误时
输入:
{
"uuid": "XXXX”,
"body_data": "abc"
}
输出:
{
"uuid": "XXXX",
"body_data": "abc",
"body_data.fild1": null,
"body_data.fild2": null
}
Re:回复: flink sql如何实现json字符数据解析?
Posted by "casel.chen" <ca...@126.com>.
社区Flink自带的那些json函数都没有解析一串json string返回一行或多行ROW的
在 2023-11-23 15:24:33,"junjie.miao@goupwith.com" <ju...@goupwith.com> 写道:
>可以看下JSON函数
>https://nightlies.apache.org/flink/flink-docs-release-1.18/docs/dev/table/functions/systemfunctions/#json-functions
>
>
>
>Junjie.M
>
>发件人: casel.chen
>发送时间: 2023-11-22 20:54
>收件人: user-zh@flink.apache.org
>主题: flink sql如何实现json字符数据解析?
>输入:
>
>{
>
> "uuid":"XXXX",
>
> "body_data": "[{\"fild1\":1"1231","fild2\":1"2341"},{"fild1\":"abc\","fild2\":"cdf\"}]"
>
>}
>
>
>
>
>输出:
>
>[
>
> {
>
>"uuid": "XXXX",
>
>"body_data: null,
>
>"body_data.fild1": "123”,
>
>"body_data.fild2": "234"
>
> },
>
> {
>
>"uuid": "XXXX",
>
>"body_data": null,
>
>"body_data.fild1": "abc",
>
>"body_data.fild2": "cdf"
>
> }
>
>]
>
>
>
>
>当格式错误时
>
>
>
>
>输入:
>
>{
>
>"uuid": "XXXX”,
>
>"body_data": "abc"
>
>}
>
>输出:
>
>{
>
>"uuid": "XXXX",
>
>"body_data": "abc",
>
>"body_data.fild1": null,
>
>"body_data.fild2": null
>
>}