Versions Compared

Old Version 7

changes.mady.by.user Velmurugan Periasamy

Saved on

compared with

New Version Current

changes.mady.by.user Harshal Chavan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


ActionSelectUpdateCreateDropAlter
IndexLock
AllReadWriteReplAdminServiceAdmin

Temporary UDF admin

RefreshRW Storage
All
URI RWX permissionComments
CREATE TABLE

X

X






X -for create external table – the location)

DROP TABLE


X
X









DESCRIBE TABLEX



X









SHOW PARTITIONSX



X









ALTER TABLE LOCATION



XX






X - for new location

ALTER PARTITION LOCATION



XX






X - for new partition location

ALTER TABLE ADD PARTITIONX


XX






X - for partition location

ALTER TABLE DROP PARTITION



XX









ALTER TABLE (all of them except the ones above)



XX









TRUNCATE TABLE
X


X









CREATE VIEW

X

X









ALTER VIEW PROPERTIES



XX









ALTER VIEW RENAME



XX









DROP VIEW PROPERTIES


X
X









DROP VIEW


X
X
ANALYZE










ANALYSE TABLEX
X















SHOW DATABASESXX
SHOW COLUMNS
XX
SHOW TABLE STATUS
XX
SHOW TABLE PROPERTIES
XX
CREATE TABLE AS SELECT
XXX
CREATE INDEX
XX
XDROP INDEX



SHOW COLUMNSX



X
XALTER INDEX REBUILDXXXALTER INDEX PROPERTIESXXXLOCK DBXXUNLOCK DBXXLOCK TABLE










CREATE TABLE AS SELECTX
X
UNLOCK TABLEXX













SELECTX



X









INSERT
X


X









UPDATE
X


X









DELETEXX


X









LOAD
X


X






X- input location

SHOW CREATE TABLEX



X









CREATE FUNCTION
X










X




DROP FUNCTION
X
X
















MSCK (metastore check)



XX









ALTER DATABASE



XX









CREATE DATABASE

X

X









DROP DATABASE


X
X









IMPORT

X

X
X










EXPORT
XXX
















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













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