FlinkErr: Unknown call expression: sum(vc)
创始人
2024-12-28 23:05:40
0

public class OverWindowTableApiTest {     public static void main(String[] args) throws Exception {         StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();         env.setParallelism(1);         StreamTableEnvironment tableEnv = StreamTableEnvironment.create(env);          DataStreamSource streamSource = env.socketTextStream("hadoop102", 7777);         SingleOutputStreamOperator map = streamSource.map(new MapFunction() {             @Override             public WaterSensor map(String value) throws Exception {                 String[] splits = value.split(",");                  WaterSensor waterSensor = new WaterSensor(splits[0], Long.valueOf(splits[1]), Integer.valueOf(splits[2]));                 return waterSensor;             }         });           // 流转表(指定表结构)         Schema schema = Schema.newBuilder()                 .column("id", "STRING")                 .column("ts", "BIGINT")                 .column("vc", "INT")                 .columnByExpression("pt" , "PROCTIME()")                 .columnByExpression("et", "TO_TIMESTAMP_LTZ(ts, 3)")                 //.watermark("et" , "source_watermark()") // 沿用流中的水位线                 .watermark("et" , "et - INTERVAL '1' SECOND ") // 重新定义水位线                 .build();         Table table = tableEnv.fromDataStream(map, schema);          // API式开窗         OverWindow w1 = Over.partitionBy($("id")).orderBy($("pt")).preceding(UNBOUNDED_ROW).following(CURRENT_ROW).as("w");          table.window(w1)                 .select(                     $("id"), $("ts"), $("vc"), $("et"), $("vc").sum().over($("w")).as("sum_vc")         ).execute().print();          env.execute();     } }

再次运行

 

成功!

相关内容

热门资讯

指引f辅助!hhpoker是真... 指引f辅助!hhpoker是真的假的,wepoker辅助透视,解密教程(有挂技术)hhpoker是真...
机巧f辅助!红龙poker辅助... 机巧f辅助!红龙poker辅助工具,红龙poker辅助工具,推荐教程(的确有挂)一、红龙poker辅...
绝活f辅助!htx矩阵wepo... 绝活f辅助!htx矩阵wepoker辅助,wepoker脚本,揭幕教程(有挂秘笈)1、htx矩阵we...
经验f辅助!wepoker辅助... 经验f辅助!wepoker辅助器,wepoker私人局透视,必备教程(有挂规律);1、上手简单,内置...
办法f辅助!wepoker怎么... 办法f辅助!wepoker怎么发冤家牌,wpk作弊最怕三个东西,教你教程(有挂助手)1、操作简单,无...
积累f辅助!德普之星透视软件免... 积累f辅助!德普之星透视软件免费入口官网,wepoker私人局规律,普及教程(有挂技术)1、许多玩家...
窍要f辅助!wpk有那种辅助吗... 窍要f辅助!wpk有那种辅助吗,德州局透视,教你教程(揭秘有挂)1)wpk有那种辅助吗辅助插件:进一...
指引f辅助!poker mas... 指引f辅助!poker master辅助,德州私人局脚本,解密教程(有挂攻略);1、德州私人局脚本脚...
学习f辅助!wejoker辅助... 学习f辅助!wejoker辅助机器人,wepoker有没有机器人,专业教程(有挂解惑)1、很好的工具...
演示f辅助!aa poker辅... 演示f辅助!aa poker辅助,佛手大菠萝有挂吗,分享教程(真的有挂)1、佛手大菠萝有挂吗免费辅助...