hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prasanth Jayachandran (JIRA)" <>
Subject [jira] [Commented] (HIVE-17884) Implement create, alter and drop workload management triggers.
Date Wed, 25 Oct 2017 01:01:00 GMT


Prasanth Jayachandran commented on HIVE-17884:

Also would recommend one other minor change (either in this patch of followup jira), while
creating resource plan will be better to remove '_' from query parallelism


we can use '_' for trigger expression counter names.

Also, trigger expression counters does not accept values other than integer. Something like
below will throw error


from usability perspective, it will be easier to specify 10GB vs values in bytes. Similarly
for time based counters, WHEN EXECUTION_TIME > 2 hours DO KILL.
can parse such counters ("10 GB"). 

> Implement create, alter and drop workload management triggers.
> --------------------------------------------------------------
>                 Key: HIVE-17884
>                 URL:
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Harish Jaiprakash
>            Assignee: Harish Jaiprakash
>         Attachments: HIVE-17884.01.patch
> Implement triggers for workload management:
> The commands to be implemented:
> CREATE TRIGGER `resourceplan_name`.`trigger_name` WHEN condition DO action;
> condition is a boolean expression: variable operator value types with 'AND' and 'OR'
> action is currently: KILL or MOVE TO pool;
> ALTER TRIGGER `plan_name`.`trigger_name` WHEN condition DO action;
> DROP TRIGGER `plan_name`.`trigger_name`;
> Also add WM_TRIGGERS to information schema.

This message was sent by Atlassian JIRA

View raw message