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