Search code examples
hiveviewpermissions

Hive sentence CREATE OR REPLACE VIEW permissions

My question is what do this sentences when exists the view.

It performs an ALTER VIEW (that don't change the permissions)

Or it performs a DROP and a CREATE (that makes that other users lost his permissions on the view).

Solution

  • create or replace is equivalent to drop and create. (You can refer to this jira - https://issues.apache.org/jira/browse/HIVE-1078). So, permissions may get reset.

    Hive permission on table can be controlled but i am not sure about views. But from my oracle background, i can say there may be problems.