CarbonData表用户权限说明
下表提供了对CarbonData Table执行相应操作所需的Hive ACL特权的详细信息。
Hive ACL权限
场景 |
所需权限 |
---|---|
DESCRIBE TABLE |
SELECT (of table) |
SELECT |
SELECT (of table) |
EXPLAIN |
SELECT (of table) |
CREATE TABLE |
CREATE (of database) |
CREATE TABLE As SELECT |
CREATE (on database), INSERT (on table), RW on data file, and SELECT (on table) |
LOAD |
INSERT (of table) RW on data file |
DROP TABLE |
OWNER (of table) |
DELETE SEGMENTS |
DELETE (of table) |
SHOW SEGMENTS |
SELECT (of table) |
CLEAN FILES |
DELETE (of table) |
INSERT OVERWRITE / INSERT INTO |
INSERT (of table) RW on data file and SELECT (of table) |
CREATE INDEX |
OWNER (of table) |
DROP INDEX |
OWNER (of table) |
SHOW INDEXES |
SELECT (of table) |
ALTER TABLE ADD COLUMN |
OWNER (of table) |
ALTER TABLE DROP COLUMN |
OWNER (of table) |
ALTER TABLE CHANGE DATATYPE |
OWNER (of table) |
ALTER TABLE RENAME |
OWNER (of table) |
ALTER TABLE COMPACTION |
INSERT (on table) |
FINISH STREAMING |
OWNER (of table) |
ALTER TABLE SET STREAMING PROPERTIES |
OWNER (of table) |
ALTER TABLE SET TABLE PROPERTIES |
OWNER (of table) |
UPDATE CARBON TABLE |
UPDATE (of table) |
DELETE RECORDS |
DELETE (of table) |
REFRESH TABLE |
OWNER (of main table) |
REGISTER INDEX TABLE |
OWNER (of table) |
SHOW PARTITIONS |
SELECT (on table) |
ALTER TABLE ADD PARTITION |
OWNER (of table) |
ALTER TABLE DROP PARTITION |
OWNER (of table) |
![](https://support.huaweicloud.com/cmpntguide-lts-mrs/public_sys-resources/note_3.0-zh-cn.png)
- 如果数据库下的表由多个用户创建,那么执行Drop database命令会失败,即使执行的用户是数据库的拥有者。
- 在二级索引中,当父表(parent table)触发时,insert和compaction将在索引表上触发。 如果选择具有过滤条件匹配索引表列的查询,用户应该为父表和索引表提供选择权限。
- LockFiles文件夹和LockFiles文件夹中创建的锁定文件将具有完全权限,因为LockFiles文件夹不包含任何敏感数据。
- 如果使用ACL,确保不要为DDL或DML配置任何被其他进程使用中的路径,建议创建新路径。
1) carbon.badRecords.location
2) 创建数据库时Db_Path及其他。
- 对于非安全集群中的Carbon ACL权限,hive-site.xml中的参数hive.server2.enable.doAs必须设置为false。 将此属性设置为false,查询将以hiveserver2进程运行的用户身份运行。