Versions Compared

Old Version 5

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










ANALYSE TABLEX














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
 

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 

 

 

...















No Ranger Auth
case REPLDUMP







X






case REPLSTATUS







X






RWSTORAGE











X


Read data from HDFS using hdfs




X