[HIVE-17954] Implement pool, user, group and trigger to pool management API's.

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Labels: TODOC3.0
• Assignee: Harish JP
• Reporter: Harish JP
• Created: 01/Nov/17 01:24
• Updated: 01/Feb/19 08:35
• Resolved: 27/Nov/17 22:28

Description

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`;

Issue Links

• blocks: HIVE-18075 verify commands on a cluster