You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "Xianxun Ye (Jira)" <ji...@apache.org> on 2021/10/15 11:00:00 UTC

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

Xianxun Ye created FLINK-24567:
----------------------------------

             Summary: 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


Now when we run this sql will throw a ValidationException
{code:java}
// code placeholder
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)