DTStack / DTStack/flinkStreamSQL

嵌套json 解析后输出的数据为null

Open
#332 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
2k
Forks
913
PR merge metrics
No merged PRs in 30d

Description

### 嵌套json 解析后输出的数据 uid字段一直为null
json日志格式
{
"time":"2020-06-15 19:16:29.243",
"topic":"room_chat",
"appname":"ms",
"info":{
"uid":427083
}
}

kafkasource 建表语句
CREATE TABLE kafka11source (
appname VARCHAR ,
topic VARCHAR ,
info.uid bigint as uid,
time VARCHAR
)
WITH (
type='kafka11',
bootstrapServers='hadoop04:9092',
offsetReset='latest',
topic='room_topic',
groupId='flink_sql,
parallelism='2',
timezone='Asia/Shanghai',
topicIsPattern ='false',
sourcedatatype ='json'
);

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.