[jira] [Comment Edited] (FLINK-24567) Support create tables using CatalogView defination

["Xianxun Ye (Jira)" <ji...@apache.org>]

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