Page History

...

Action	Select	Insert	Delete	Ownership	Admin	URI Privilege (RWX Permission + Ownership)
CREATE TABLE				Y (of database)		Y (for create external table – the location)
DROP TABLE				Y
DESCRIBE TABLE	Y
SHOW PARTITIONS	Y
ALTER TABLE LOCATION				Y		Y (for new location)
ALTER PARTITION LOCATION				Y		Y (for new partition location)
ALTER TABLE ADD PARTITION		Y				Y (for partition location)
ALTER TABLE DROP PARTITION			Y
ALTER TABLE (all of them except the ones above)				Y
TRUNCATE TABLE				Y
CREATE VIEW	Y + G
ALTER VIEW PROPERTIES				Y
ALTER VIEW RENAME				Y
DROP VIEW PROPERTIES				Y
DROP VIEW				Y
ANALYZE TABLE	Y	Y
SHOW COLUMNS	Y
SHOW TABLE STATUS	Y
SHOW TABLE PROPERTIES	Y
CREATE TABLE AS SELECT	Y (of input)			Y (of database)
CREATE INDEX				Y (of table)
DROP INDEX				Y
ALTER INDEX REBUILD				Y
ALTER INDEX PROPERTIES				Y
QUERY (insert, select queries)	Y (input)	Y (output)	Y (output)
LOAD		Y (output)	Y (output)			Y (input location)
SHOW CREATE TABLE	Y+G
CREATE FUNCTION					Y
DROP FUNCTION					Y
CREATE MACRO					Y
DROP MACRO					Y
MSCK (metastore check)					Y
ALTER DATABASE					Y
CREATE DATABASE						Y (if custom location specified)
EXPLAIN	Y
DROP DATABASE				Y

...

Space shortcuts