[ https://issues.apache.org/jira/browse/DRILL-2589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris Westin updated DRILL-2589: -------------------------------- Fix Version/s: 0.9.0 > Creating a view with duplicate column names should fail or give a warning to > the user > ------------------------------------------------------------------------------------- > > Key: DRILL-2589 > URL: https://issues.apache.org/jira/browse/DRILL-2589 > Project: Apache Drill > Issue Type: Bug > Components: Metadata > Affects Versions: 0.8.0 > Reporter: Rahul Challapalli > Assignee: Steven Phillips > Fix For: 0.9.0 > > > git.commit.id.abbrev=4d398ed > View DDL : > {code} > create view v1 as select pageRank, pageRank from `/dfs/parquet/rankings`; > {code} > The above view creation succeeds and drill silently renames the columns. > Postgres does not allow this behavior. > Below is the description of the view > {code} > describe v1; > +-------------+------------+-------------+ > | COLUMN_NAME | DATA_TYPE | IS_NULLABLE | > +-------------+------------+-------------+ > | pageRank | ANY | NO | > | pageRank0 | ANY | NO | > +-------------+------------+-------------+ > {code} > In most cases the reason someone would create such a view is by mistake. So > we should either not allow it or give a warning to the user in such situations -- This message was sent by Atlassian JIRA (v6.3.4#6332)