[jira] [Created] (DRILL-2589) Creating a view with duplicate column names should fail or give a warning to the user

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

Rahul Challapalli created DRILL-2589:
----------------------------------------

             Summary: 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
            Reporter: Rahul Challapalli
            Assignee: Steven Phillips


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)