Page History

Action

Select

Update

Create

Drop

Alter

IndexLock

All

Read

Write

ReplAdmin

ServiceAdmin

Temporary UDF admin

Refresh

RW Storage

All

URI RWX permission

Comments

CREATE TABLE

X

X -for create external table – the location)


DROP TABLE

X


DESCRIBE TABLE	X

X


SHOW PARTITIONS	X

X


ALTER TABLE LOCATION

X

X - for new location


ALTER PARTITION LOCATION

X

X - for new partition location


ALTER TABLE ADD PARTITION

X

X - for partition location


ALTER TABLE DROP PARTITION

X


ALTER TABLE (all of them except the ones above)

X


TRUNCATE TABLE

X


CREATE VIEW

X


ALTER VIEW PROPERTIES

X


ALTER VIEW RENAME

X


DROP VIEW PROPERTIES

X


DROP VIEW

X

ANALYZE TABLEX

ANALYSE TABLE

X

SHOW COLUMNSX X SHOW TABLE STATUSX X SHOW TABLE PROPERTIESX X CREATE TABLE AS SELECTX X X CREATE INDEX X X X DROP INDEX X X X ALTER INDEX REBUILD XX X ALTER INDEX PROPERTIES XX X LOCK DB XX UNLOCK DB XX LOCK TABLE XX UNLOCK TABLE XX SELECTX X INSERT X X UPDATE X X DELETE X X LOADX XX- input location SHOW CREATE TABLEX X CREATE FUNCTION X X DROP FUNCTION X X MSCK (metastore check) X Will be addressed by Hive in Erie-M20 ALTER DATABASE X X CREATE DATABASE X X DROP DATABASE X X IMPORTX X X EXPORTXX X GRANT

SHOW DATABASES

X

SHOW COLUMNS

X

CREATE TABLE AS SELECT

X

SELECT

X

INSERT

X

UPDATE

X

DELETE

X

LOAD

X

X- input location

SHOW CREATE TABLE

X

CREATE FUNCTION

X

DROP FUNCTION

MSCK (metastore check)

X

ALTER DATABASE

X

CREATE DATABASE

X

DROP DATABASE

X

IMPORT

X

EXPORT

GRANT

In Ranger - User should be "ADMIN"

REVOKE

In Ranger - User should be "ADMIN"

SHOW GRANT

Not Supported


CREATE ROLE

Not Supported


DROP ROLE

Not Supported

SHOW CURRENT ROLES

Not Supported


REVOKE ROLE

Not Supported

GRANT ROLE

Not Supported

SHOW ROLE

Not Supported


SHOW ROLE GRANT

Not Supported


SHOW PRINCIPALS

Not Supported


SHOW CONF

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

No Ranger Auth

Not Supported in Ranger

RESET

No Ranger Auth

SET

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

...

No Ranger Auth

case REPLDUMP

X

case REPLSTATUS

X

RWSTORAGE

X

Read data from HDFS using hdfs

X

Space shortcuts

Page tree

Versions Compared

Old Version 4

New Version Current

Key