Flink JDBC CONNECT 识别不了数据库模式？

最新推荐文章于 2024-08-07 09:54:31 发布

JINGCHENG_XIE

最新推荐文章于 2024-08-07 09:54:31 发布

阅读量660

点赞数

文章标签： flink java

本文链接：https://blog.csdn.net/JINGCHENG_XIE/article/details/106146146

版权

在使用 Flink 的 JDBC 连接创建 Table 时，遇到只能识别 'public' 模式下表的困扰。尝试指定模式名.表名导致错误。寻求解决方案。

摘要由CSDN通过智能技术生成

 String dimDDL2 = "CREATE TABLE detectorMatch (" +
                "  job_id INT," +
                "  update_time TIMESTAMP(3)," +
                "  run_time TIMESTAMP(3), " +
                "  name VARCHAR," +
                "  note VARCHAR," +
                "  job_path VARCHAR, " +
                "  scheduler_job_name VARCHAR," +
                "  classes VARCHAR," +
                "  scheduler_strategy VARCHAR " +
                ") WITH (" +
                "  'connector.type' = 'jdbc'," +
                "  'connector.url' = 'jdbc:postgresql://192.168.56.51:5433/gp_sydb_hz'," +
//                "  'connector.schema' = 'etl_dim'," +
                "  'connector.table' = 'etl_table_update_ti