[
https://issues.apache.org/jira/browse/IMPALA-14909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steve Carlin resolved IMPALA-14909.
-----------------------------------
Resolution: Fixed
> 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
> Priority: Major
>
> 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
