FlinkErr: Unknown call expression: sum(vc)

public class OverWindowTableApiTest {
    public static void main(String[] args) throws Exception {
        StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();
        env.setParallelism(1);
        StreamTableEnvironment tableEnv = StreamTableEnvironment.create(env);

        DataStreamSource<String> streamSource = env.socketTextStream("hadoop102", 7777);
        SingleOutputStreamOperator<WaterSensor> map = streamSource.map(new MapFunction<String, WaterSensor>() {
            @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();
    }
}

再次运行

 

成功!

相关推荐

最近更新

  1. docker php8.1+nginx base 镜像 dockerfile 配置

    2024-07-16 14:38:03       67 阅读
  2. Could not load dynamic library ‘cudart64_100.dll‘

    2024-07-16 14:38:03       71 阅读
  3. 在Django里面运行非项目文件

    2024-07-16 14:38:03       58 阅读
  4. Python语言-面向对象

    2024-07-16 14:38:03       69 阅读

热门阅读

  1. 常见的排序方法

    2024-07-16 14:38:03       22 阅读
  2. 内存泄漏和内存溢出

    2024-07-16 14:38:03       18 阅读
  3. 【爬虫基础入门课件:第一课:python基础内容】

    2024-07-16 14:38:03       16 阅读
  4. sklearn基础教程

    2024-07-16 14:38:03       21 阅读
  5. ICPC(武汉icpc邀请赛)

    2024-07-16 14:38:03       22 阅读
  6. SAP_ABAP相关日语单词

    2024-07-16 14:38:03       22 阅读
  7. Markdown2Html全面使用教程:从入门到精通

    2024-07-16 14:38:03       17 阅读