...
Y + G: Privilege "WITH GRANT OPTION" required.
Action | Select | Insert | Update | 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) | |||||||
SELECT | Y | ||||||||
INSERT | Y | Y ( | inputfor OVERWRITE) | Y (output) | Y (output)|||||
UPDATE | Y | ||||||||
DELETE | Y | ||||||||
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 |
Configuration
Set the following in hive-site.xml:
...