You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@impala.apache.org by "Steve Carlin (Jira)" <ji...@apache.org> on 2026/04/20 23:28:00 UTC

[jira] [Created] (IMPALA-14909) Calcite planner: Some views with column list do not validate

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)