hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prasanth Jayachandran (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-17884) Implement create, alter and drop workload management triggers.
Date Thu, 26 Oct 2017 18:56:01 GMT

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

Mime
View raw message