Flink sql之hive catalog踩雷记

先上代码：

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
    | )