[
https://issues.apache.org/jira/browse/FLINK-24567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xianxun Ye updated FLINK-24567:
-------------------------------
Description:
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?
was:
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?
> 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)
