[
https://issues.apache.org/jira/browse/HIVE-17884?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16221013#comment-16221013
]
Prasanth Jayachandran commented on HIVE-17884:
----------------------------------------------
lgtm, +1.
minor thing which I will take care in HIVE-17622
"=" expressions are hard to evaluate, since we do trigger validate only at
certain intervals (every 500ms) in most cases it won't be possible to evaluate
"=" expression. Triggers are used mostly in the context of "hard limits", we
should only support ">" IMHO or something like "counterName EXCEEDS
counterValue DO KILL". Not required in this patch though.
> Implement create, alter and drop workload management triggers.
> --------------------------------------------------------------
>
> Key: HIVE-17884
> URL: https://issues.apache.org/jira/browse/HIVE-17884
> Project: Hive
> Issue Type: Sub-task
> Reporter: Harish Jaiprakash
> Assignee: Harish Jaiprakash
> Attachments: HIVE-17884.01.patch, HIVE-17884.02.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' support.
> 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
(v6.4.14#64029)
