Steve Carlin created IMPALA-14909:
-------------------------------------
Summary: Calcite planner: Some views with column list do not
validate
Key: IMPALA-14909
URL: https://issues.apache.org/jira/browse/IMPALA-14909
Project: IMPALA
Issue Type: Sub-task
Reporter: Steve Carlin
The following view does not validate with the Calcite planner
create view functional.sample_view (abc) as
select sum(bigint_col) from functional.alltypestiny
...because the view stored in the database has a dummy column which fails SQL
analysis. The view in the database is stored with a _c0 column that looks like
this if you run a "show create view"
CREATE VIEW functional.sample_view AS
SELECT sample_view.`_c0` abc FROM (SELECT sum(bigint_col)
FROM functional.alltypestiny) sample_view
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
