FlinkSQL Kafka to Kafka

最新推荐文章于 2024-07-21 18:22:05 发布

訾零

最新推荐文章于 2024-07-21 18:22:05 发布

阅读量1k

点赞数 1

分类专栏： Flink 文章标签： flinksql

本文链接：https://blog.csdn.net/lingeio/article/details/107969282

版权

Apache Kafka SQL Connector

FlinkSql 读 Kafka

import org.apache.flink.streaming.api.scala._
import org.apache.flink.table.api.EnvironmentSettings
import org.apache.flink.table.api.bridge.scala.StreamTableEnvironment
import org.apache.flink.types.Row

/**
  * flink sql read kafka
  *
  * create by LiuJinHe 2020/8/12
  */
object FlinkSqlReadKafka {

  def main(args: Array[String]): Unit = {
    // 初始化 stream 环境
    // 本地测试，需要 flink-runtime-web 依赖
    val env = StreamExecutionEnvironment.createLocalEnvironmentWithWebUI()
    env.setParallelism(1)
    //    val env = StreamExecutionEnvironment.getExecutionEnvironment

    // 创建 streamTable 环境
    val settings: EnvironmentSettings = EnvironmentSettings
      .newInstance()
      .useBlinkPlanner()
      .inStreamingMode()
      .build()

    val tableEnv: StreamTableEnvironment = StreamTableEnvironment.create(env, settings)
    val kafkaSql =
      """
        |create temporary table kafkaTable (
        | user_name string,
        | user_id bigint,
        | item_id bigint
        |) with (
        | 'connector' = 'kafka',
        | 'topic' = 'flink_test',
        | 'properties.bootstrap.servers' = 'localhost:9092',
        | 'properties.group.id' = 'flink-test-group',
        | 'format' = 'json',
        | 'scan.startup.mode' = 'latest-offset'
        |)
      """.stripMargin

    tableEnv.executeSql(kafkaSql)

    val table = tableEnv.from("kafkaTable")
    //  val table = tableEnv.sqlQuery("select * from kafkaTable")

    val resultDStream = tableEnv.toAppendStream[Row](table)
    
    resultDStream.print()

    env.execute("flink sql read kafka")
  }
}

读写 Kafka

import org.apache.flink.api.common.restartstrategy.RestartStrategies
import org.apache.flink.streaming.api.{CheckpointingMode, TimeCharacteristic}
import org.apache.flink.streaming.api.environment.