[
https://issues.apache.org/jira/browse/HIVE-17954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Harish Jaiprakash updated HIVE-17954:
-------------------------------------
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`;
was:
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`;
-- Trigger to pool mappings.
ALTER RESOURCE PLAN `resource_plan`
ADD TRIGGER `trigger_name` TO `pool_path`;
ALTER RESOURCE PLAN `resource_plan`
DROP TRIGGER `trigger_name` TO `pool_path`;
-- 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`;
> 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
> 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
>
>
> 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
(v6.4.14#64029)
