Action | Select | Update | Create | Drop | Alter |
Index | Lock | All | Read | Write | ReplAdmin | ServiceAdmin | Temporary UDF admin | Refresh | RW Storage |
All | URI RWX permission | Comments |
| | | | | |
|
| X |
|
|
|
|
|
|
| X -for create external table – the location) |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | X |
|
|
|
|
|
|
| X - for new partition location |
| |
|
|
ALTER TABLE ADD PARTITION |
| | | | | | X |
|
|
|
|
|
|
| X - for partition location |
| |
|
|
ALTER TABLE DROP PARTITION |
| | | | | | |
|
|
|
|
|
|
|
|
|
|
ALTER TABLE (all of them except the ones above) |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ANALYZE | | | | | | X | | | | SHOW COLUMNS | X | | | | | | | X | | | |
SHOW TABLE STATUS | X | | | | | | | X | | | |
SHOW TABLE PROPERTIES | X | | | | | | | X | | | |
CREATE TABLE AS SELECT | X | | X | | | | | X | | | |
CREATE INDEX | | | X | | | X | | X | | | |
DROP INDEX | | | | X | | X | | X | | | |
ALTER INDEX REBUILD | | | | | X | X | | X | | | |
ALTER INDEX PROPERTIES | | | | | X | X | | X | | | |
LOCK DB | | | | | | | X | X | | | |
UNLOCK DB | | | | | | | X | X | | | |
LOCK TABLE | | | | | | | X | X | | | |
UNLOCK TABLE | | | | | | | X | X | | | |
SELECT | X | | | | | | | X | | | |
INSERT | | X | | | | | | X | | | |
UPDATE | | X | | | | | | X | | | |
DELETE | | X | | | | | | X | | | |
LOAD | X | | | | | | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SHOW DATABASES | X | X | X | X | X | X | X | X | X | X | X | X | X |
|
|
|
SHOW COLUMNS | X |
|
|
|
| X |
|
|
|
|
|
|
|
|
|
|
CREATE TABLE AS SELECT | X |
| X |
|
|
|
|
|
|
|
|
|
|
|
|
|
SELECT | X |
|
|
|
| X |
|
|
|
|
|
|
|
|
|
|
INSERT |
| X |
|
|
| X |
|
|
|
|
|
|
|
|
|
|
UPDATE |
| X |
|
|
| X |
|
|
|
|
|
|
|
|
|
|
DELETE | X | X |
|
|
| X |
|
|
|
|
|
|
|
|
|
|
LOAD |
| X |
|
|
| X |
|
|
|
|
|
|
| X- input location |
| | | | | | | | | | | | | X | | | | | | | X | | | X | | | | | | | | | | | X | | Will be addressed by Hive in Erie-M20 | | | | | | | | | | | | | | | | | | | | | | | | | X | | | | X | X | | | | | | X | | | | | | | | | | | | |
|
|
|
|
|
|
|
|
|
|
|
|
|
| In Ranger - User should be "ADMIN" |
| | | | | | | |
|
|
|
|
|
|
|
|
|
|
|
|
|
| In Ranger - User should be "ADMIN" |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | No Ranger Auth | | ADD | | | | | | | | | | No Ranger Auth | |
DELETE | | | | | | | | | | No Ranger Auth | |
COMPILE | | | | | | | | | | No Ranger Auth | |
DFS | | | | | | | | | | No Ranger Auth | |
RESET | | | | | | | | | | No Ranger Auth | |
SET | | | | | | | | | | No Ranger Auth | |
DESCRIBE TABLE | | | | | | | | | | No Ranger Auth | |
SHOW FUNCTION | | | | | | | | | | No Ranger Auth | |
DESCRIBE FUNCTION | | | | | | | | | | No Ranger Auth | |
DROP MACRO | | | | | | | | | | No Ranger Auth | |
CREATE MACRO | | | | | | | | | | No Ranger Auth | |
SHOW LOCKS | | | | | | | | | | No Ranger Auth | |
SHOW TRANSACTIONS | | | | | | | | | | No Ranger Auth | |
EXPLAIN | | | | | | | | | | No Ranger Auth | |
...
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
LIST FILE[S] , LIST JAR[S], LIST ARCHIVE[S] |
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
ADD FILE[S] , ADD JAR[S], ADD ARCHIVE[S] |
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
DELETE FILE[S] , DELETE JAR[S] , DELETE ARCHIVE[S] |
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
COMPILE |
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
DFS |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Not Supported in Ranger |
|
RESET |
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
SET |
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
SHOW FUNCTION |
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
DESCRIBE FUNCTION |
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
DROP MACRO |
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
CREATE MACRO |
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
SHOW LOCKS |
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
SHOW TRANSACTIONS |
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
EXPLAIN |
|
|
|
|
|
|
|
|
|
|
|
|
|
| No Ranger Auth |
|
case REPLDUMP |
|
|
|
|
|
|
|
| X |
|
|
|
|
|
|
|
case REPLSTATUS |
|
|
|
|
|
|
|
| X |
|
|
|
|
|
|
|
RWSTORAGE |
|
|
|
|
|
|
|
|
|
|
|
| X |
|
|
|
Read data from HDFS using hdfs |
|
|
|
|
| X |
|
|
|
|
|
|
|
|
|
|