Flink_SQL时间窗口聚合数据

最新推荐文章于 2024-09-12 22:10:46 发布

a 茶叶蛋吃蛋白不吃蛋黄

最新推荐文章于 2024-09-12 22:10:46 发布

阅读量791

点赞数

文章标签： flink sql kafka

本文链接：https://blog.youkuaiyun.com/qq_44426756/article/details/118025120

版权

package com.ygy.gmall.realtime.test3;
import org.apache.flink.streaming.api.environment.StreamExecutionEnvironment;
import org.apache.flink.table.api.bridge.java.StreamTableEnvironment;
public class Flink_SQL_groupby {
   

    public static void main(String[] args) throws Exception {
   
        //环境
        StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();
        env.setParallelism(1);
        //创建tableEnv
        StreamTableEnvironment tableEnv = StreamTableEnvironment.create(env);
        //展现测试流
        tableEnv.executeSql("CREATE TABLE kafka_source_ygy_str_test (\n" +
                "    `str` string,\n" +
                "    proctime as PROCTIME()\n" +
                ") WITH (\n" +
                "    'connector' = 'kafka',\n" +
                "    'topic' = 'ygy_str_test',\n" +
                "    'properties.bootstrap.servers' = 'xxxx:9092',\n" +
                "    'properties.group.id' = 'ygy_str_test_group',\n" +
                "    'scan.startup.mode' = 'latest-offset',\n" +
                "    'format' = 'csv',\n" +
                "    'csv.ignore-parse-errors' = 'true',\n" +
                "    'csv.field-delimiter' = '\\t'\n"