Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
git.commit.id.abbrev=5b57294
Currently, an existing view can be replaced by using "create view" syntax. For example, I have an existing view named student_v . Then I run a create view with the same name:
0: jdbc:drill:schema=dfs> create view student_v as select * from voter;
----------------------+
ok | summary |
----------------------+
true | View 'student_v' replaced successfully in 'dfs.default' schema |
----------------------+
1 row selected (0.544 seconds)
Like oracle and postgres, this should not be allowed. A user needs to use "create or replace view ..." syntax.