flinkSQL-udf Row中有多个Array格式编写
需求:今天想要编写一个UDF函数,返回的结果是一个嵌套的类型
- 数据的format为
{
"ner":{
"vctry":[{
"w":"xxx",
"v":"zzz"
}],
"vorg":[{
"w":"xxx",
"v":"zzz"
}]
}
}
- 转为flinkSql模式为
ner ROW<vctry ARRAY<ROW<w STRING,v STRING>>, vorg ARRAY<ROW<w STRING,v STRING>>>
UDF编写
- 编写- type1
private Row deal() {
return Row.of(
Row.of(Row1[],Row2[])
);
}
- 编写- type2
private Row deal() {
RowKind rowKind = RowKind.fromByteValue((byte) 0);
Row row = new Row(rowKind, 2);
row.setField(1, Row1[])
row.setField(2, Row2[])
return Row.of(row);
}