[
https://issues.apache.org/jira/browse/DRILL-2589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Venki Korukanti reassigned DRILL-2589:
--------------------------------------
Assignee: Venki Korukanti (was: Steven Phillips)
> 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: Venki Korukanti
> 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)
