[
https://issues.apache.org/jira/browse/FLINK-20466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
godfrey he updated FLINK-20466:
-------------------------------
Component/s: (was: Table SQL / Planner)
Table SQL / API
> Table 'EXPR$1' not found with UNION ALL
> ---------------------------------------
>
> Key: FLINK-20466
> URL: https://issues.apache.org/jira/browse/FLINK-20466
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / API
> Affects Versions: 1.11.1
> Reporter: wxmimperio
> Priority: Major
> Labels: stale-major
>
>
> {code:java}
> CREATE TABLE table_01 ( aaa varchar, bbb varchar) WITH(.......);
> CREATE TABLE table_02 ( aaa varchar, bbb varchar) WITH(.......);
> create view my_view as
> select aaa,bbb from (
> select aaa,bbb from table_01
> union all
> select aaa,bbb from table_02
> );
> create table bsql_log ( aaa varchar, bbb varchar) with ( 'connector' =
> 'log');
> insert into bsql_log SELECT aaa,bbb FROM my_view
> {code}
>
> Run the above code will report an error：
> {code:java}
> org.apache.calcite.runtime.CalciteContextException: From line 1, column 8 to
> line 1, column 15: Table 'EXPR$1' not found
> {code}
> But if I assign an alias to the result of union all, it can be normal.
> {code:java}
> create view my_view as
> select aaa,bbb from (
> select aaa,bbb from table_01
> union all
> select aaa,bbb from table_02
> ) as union_result;
> {code}
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
