[
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)
