Versions Compared

Old Version 3

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










ANALYSE TABLEX
      X   















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



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