Versions Compared

Old Version 6

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


XX






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   










ANALYSE TABLEX














SHOW DATABASESX
    
  
X
   
SHOW COLUMNS
X
     
 
X
   SHOW TABLE STATUS
X
      
X
   SHOW TABLE PROPERTIES
X
     
 
X
   
CREATE TABLE AS SELECT
X
 
X
   
 
X
   CREATE INDEX
  
X
  
X
 



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




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   ALTER DATABASE    X  X   CREATE DATABASE  X    X   DROP DATABASE   X   X   IMPORTX X    X   EXPORTXX     X   GRANT         
















MSCK (metastore check)
       X Will be addressed by Hive in Erie-M20 




XX









ALTER DATABASE



XX









CREATE DATABASE

X

X









DROP DATABASE


X
X









IMPORT

X

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
       
  














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