You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "zhangbutao (JIRA)" <ji...@apache.org> on 2019/02/01 08:36:00 UTC
[jira] [Commented] (HIVE-17954) Implement pool, user, group and
trigger to pool management API's.
[ https://issues.apache.org/jira/browse/HIVE-17954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16758099#comment-16758099 ]
zhangbutao commented on HIVE-17954:
-----------------------------------
hi, i am testing user and group mappings, like "CREATE USER MAPPING "user1" IN plan_2 TO def". howerver, it seems that the user mapping is no deffective, because any query is executed by user hive (doAS is not allowed in workload management). I can not find any way to make one user to use its exclusive pool. So, anyone know how to configure multi-tenancy using workoad management ? Thanks !
> Implement pool, user, group and trigger to pool management API's.
> -----------------------------------------------------------------
>
> Key: HIVE-17954
> URL: https://issues.apache.org/jira/browse/HIVE-17954
> Project: Hive
> Issue Type: Sub-task
> Reporter: Harish Jaiprakash
> Assignee: Harish Jaiprakash
> Priority: Major
> Labels: TODOC3.0
> Fix For: 3.0.0
>
> Attachments: HIVE-17954.01.patch, HIVE-17954.02.patch, HIVE-17954.03.patch, HIVE-17954.04.patch, HIVE-17954.05.patch, HIVE-17954.06.patch, HIVE-17954.07.patch, HIVE-17954.08.patch, HIVE-17954.09.patch, HIVE-17954.10.patch
>
>
> Implement the following commands:
> -- Pool management.
> CREATE POOL `resource_plan`.`pool_path` WITH
> ALLOC_FRACTION=`fraction`,
> QUERY_PARALLELISM=`parallelism`,
> SCHEDULING_POLICY=`policy`;
> ALTER POOL `resource_plan`.`pool_path` SET
> PATH = `new_path`,
> ALLOC_FRACTION = `fraction`,
> QUERY_PARALLELISM = `parallelism`,
> SCHEDULING_POLICY = `policy`;
> DROP POOL `resource_plan`.`pool_path`;
> -- Adding triggers to pools.
> ALTER POOL `resource_plan`.`pool_path` ADD TRIGGER `trigger_name`;
> ALTER POOL `resource_plan`.`pool_path` DROP TRIGGER `trigger_name`;
> -- User/Group to pool mappings.
> CREATE USER|GROUP MAPPING `resource_plan`.`group_or_user_name`
> TO `pool_path` WITH ORDERING `order_no`;
> DROP USER|GROUP MAPPING `resource_plan`.`group_or_user_name`;
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)