Versions Compared

Old Version 2

changes.mady.by.user Ramesh Mani

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
    




X
 
 
X






X - for new location
  


ALTER PARTITION LOCATION
    




X
  
X






X - for new partition location
  


ALTER TABLE ADD PARTITION
    
X


X
  
X






X - for partition location
  


ALTER TABLE DROP PARTITION
    




X
  
X
 
  










ALTER TABLE (all of them except the ones above)
    




X
  
X
   










TRUNCATE TABLE
 

X
     



X
   










CREATE VIEW
  


X
    


X
   










ALTER VIEW PROPERTIES
  
  




X
 
 
X
   










ALTER VIEW RENAME
    




X
 
 
X
  
 










DROP VIEW PROPERTIES
   



X
 
  

X
   










DROP VIEW
 
  



X
   

X
   ANALYZE










ANALYSE TABLEX
      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      















SHOW DATABASESXXXXXXXXXXXXX


SHOW COLUMNSX



X









CREATE TABLE AS SELECTX
X












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)
       X Will be addressed by Hive in Erie-M20




XX
 










ALTER DATABASE
  
  




X
 
 
X
   










CREATE DATABASE
  


X
   
 


X
  
 










DROP DATABASE
   



X
 
  

X
   










IMPORT

X
 


X
    X   










EXPORT
XX     X   
















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 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