Flink SQL代码示例（scala版本）

一、创建SBT项目，添加以下依赖

 

// https://mvnrepository.com/artifact/org.apache.flink/flink-table
libraryDependencies += "org.apache.flink" %% "flink-table" % "1.2.0"
// https://mvnrepository.com/artifact/org.apache.flink/flink-scala
libraryDependencies += "org.apache.flink" %% "flink-scala" % "1.2.0"

二、

 

package Table

import org.apache.flink.api.scala.ExecutionEnvironment
import org.apache.flink.table.api.TableEnvironment
import org.apache.flink.table.sinks.CsvTableSink

/**
  * Author: HuangWei
  * Date: 18-6-27 下午6:10
  */
case class ID(id:String)
case class Mark(col1:String,col2:String,col3:String,col4:String,col5:String,col6:String,col7:String,col8:String,col9:String,col10:String,col11:String,col12:String,col13:String,col14:String,col15:String,col16:String,col17:String,col18:String,col19:String,col20: