[ https://issues.apache.org/jira/browse/FLINK-24567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429825#comment-17429825 ]
Xianxun Ye edited comment on FLINK-24567 at 10/18/21, 5:53 AM: --------------------------------------------------------------- Yes. [~jark] this syntax is good. was (Author: yesorno): {{Yes. [~jark] }}this syntax is good. > Support create tables using CatalogView defination > -------------------------------------------------- > > Key: FLINK-24567 > URL: https://issues.apache.org/jira/browse/FLINK-24567 > Project: Flink > Issue Type: Improvement > Components: Table SQL / API > Reporter: Xianxun Ye > Priority: Major > > Now when we run this sql will throw a ValidationException > {code:java} > sql("create view vi as select * from slothTest.testdb.animal"); > sql("CREATE TABLE print_table WITH ('connector' = 'blackhole') LIKE vi > (EXCLUDING ALL)"); > {code} > {code:java} > org.apache.flink.table.api.ValidationException: Source table > '`default_catalog`.`default_database`.`vi`' of the LIKE clause can not be a > VIEW, at line 1, column 60 > {code} > Create table from some views during running a perfermence test job could be > usefull. > hello [~dwysakowicz] what do you think about this feature? -- This message was sent by Atlassian Jira (v8.3.4#803005)