Description
git.commit.id.abbrev=4d398ed
View DDL :
create view v1 as select pageRank, pageRank from `/dfs/parquet/rankings`;
The above view creation succeeds and drill silently renames the columns. Postgres does not allow this behavior.
Below is the description of the view
describe v1; +-------------+------------+-------------+ | COLUMN_NAME | DATA_TYPE | IS_NULLABLE | +-------------+------------+-------------+ | pageRank | ANY | NO | | pageRank0 | ANY | NO | +-------------+------------+-------------+
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