先上代码:
val streamEnv = StreamExecutionEnvironment.getExecutionEnvironment streamEnv.setParallelism(5) streamEnv.setStreamTimeCharacteristic(TimeCharacteristic.ProcessingTime) val tableEnvSettings = EnvironmentSettings.newInstance() .useBlinkPlanner() .inStreamingMode() .build() val tableEnv = StreamTableEnvironment.create(streamEnv, tableEnvSettings) val hive_catalog = new HiveCatalog( "flink", // catalog name "default", // default database "G:\\Flink SQL开发文件", // Hive config (hive-site.xml) directory "1.1.0" // Hive version )//todo kafka 数据源创建表 val createSourceTableSql = """CREATE TABLE flink_test_01 ( | user_id STRING, | item_id STRING, | category_id STRING, | behavior STRING, | ts TIMESTAMP(3), | proctime as proctime(), | WATERMARK FOR ts as ts - INTERVAL '5' SECOND | )