...
The following table shows the minimum permissions required for Hive operations under this authorization model:
Operation | Database | Database | Table | Table |
| Read Access | Database Write Access | Table Read Access | Table Write Access |
|---|---|---|---|---|---|---|---|---|---|
LOAD |
|
|
| X | |||||
EXPORT |
|
| X |
| |||||
IMPORT |
|
|
| X | |||||
CREATE TABLE |
| X |
|
| |||||
CREATE TABLE AS SELECT |
| X | X |
| |||||
DROP TABLE |
| X |
|
| |||||
SELECT |
|
| X |
| |||||
ALTER TABLE |
|
|
| X | |||||
SHOW TABLES | X |
|
|
|
...