Hi, Roc. *Note:* in the future, please send this type of questions to the user mailing list instead (user@flink.apache.org)!
If I understand your question correctly, this is possible using the LIKE clause and a registered catalog. There is currently no implementation for the MySQL JDBC catalog, but this is in the roadmap [1,2]. Once you register a catalog, you could do: CREATE TABLE mapping_table WITH ( ... ) LIKE full_path_to_source_table; Again, as of Flink 1.11 this only works for Postgres, not yet MySQL. I'm copying in Bowen as he might be able to give more information on the roadmap. Marta [1] https://issues.apache.org/jira/browse/FLINK-15352 [2] https://cwiki.apache.org/confluence/display/FLINK/FLIP-93%3A+JDBC+catalog+and+Postgres+catalog On Tue, Sep 22, 2020 at 9:44 AM Roc Marshal <flin...@126.com> wrote: > Hi, everyone! > > When using flink sql DDL to create a mysql mapping table, does > flink support the automatic rendering of the target table schema if we put > no column-names in `create table table_name_mapping2mysql () with (...)`? > If this feature is not supported, is it necessary to consider improving it? > > Thank you. > Best, Roc.