flink TableAPI和SQL的hello world

最新推荐文章于 2025-06-16 10:52:36 发布

原创最新推荐文章于 2025-06-16 10:52:36 发布 · 440 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#flink #sql #apache

flink 专栏收录该内容

11 篇文章

订阅专栏

该代码示例展示了如何使用Apache Flink的Table API和SQL操作数据。首先，从集合中创建DataStream<SensorReading>，然后通过Table API和SQL查询过滤特定传感器(id='sensor_1')的数据，并打印结果。这体现了Flink在流处理中的数据查询和转换能力。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

代码

import com.zjc.bean.SensorReading;
import org.apache.flink.streaming.api.datastream.DataStream;
import org.apache.flink.streaming.api.datastream.DataStreamSource;
import org.apache.flink.streaming.api.environment.StreamExecutionEnvironment;
import org.apache.flink.table.api.Table;
import org.apache.flink.table.api.java.StreamTableEnvironment;
import org.apache.flink.types.Row;

import java.util.Arrays;

public class Test1_Case1 {
    public static void main(String[] args) throws Exception{
        StreamExecutionEnvironment executionEnvironment = StreamExecutionEnvironment.getExecutionEnvironment();
        DataStream<SensorReading> sensorReadingDataStreamSource = executionEnvironment.fromCollection(Arrays.asList(
                new SensorReading("sensor_1", 1547718199L, 35.8),
                new SensorReading("sensor_6", 1547718201L, 15.4),
                new SensorReading("sensor_7", 1547718202L, 6.7),
                new SensorReading("sensor_10", 1547718205L, 38.1)
                )
        );
        // 方法1，table api
        StreamTableEnvironment streamTableEnvironment = StreamTableEnvironment.create(executionEnvironment);
        Table sensorTable = streamTableEnvironment.fromDataStream(sensorReadingDataStreamSource);
        Table sensorSelect = sensorTable.select("id, temperature").where("id='sensor_1'");
        streamTableEnvironment.toAppendStream(sensorSelect, Row.class).print("table api");
        // 方法2，sql方式
        streamTableEnvironment.createTemporaryView("sqlTable",sensorReadingDataStreamSource);
        String sql = "select id,temperature from sqlTable where id = 'sensor_1'";
        Table sqlQuery = streamTableEnvironment.sqlQuery(sql);
        streamTableEnvironment.toAppendStream(sqlQuery, Row.class).print("sql");
        executionEnvironment.execute();

    }
}

结果：
在这里插入图片描述