[ https://issues.apache.org/jira/browse/HIVE-17508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16189043#comment-16189043 ]
Prasanth Jayachandran commented on HIVE-17508: ---------------------------------------------- [~sershe] Addressed review comments. Also JDBC with mini llap tests are disabled for now. Will be easier to enable them after committing the hive commands patch for rule creation. Without it have to put holes around to pass the rules for tests. Will create a followup for the same. > Implement pool rules and triggers based on counters > --------------------------------------------------- > > Key: HIVE-17508 > URL: https://issues.apache.org/jira/browse/HIVE-17508 > Project: Hive > Issue Type: Sub-task > Affects Versions: 3.0.0 > Reporter: Prasanth Jayachandran > Assignee: Prasanth Jayachandran > Attachments: HIVE-17508.1.patch, HIVE-17508.2.patch, > HIVE-17508.3.patch, HIVE-17508.3.patch, HIVE-17508.4.patch, > HIVE-17508.WIP.2.patch, HIVE-17508.WIP.patch > > > Workload management can defined Rules that are bound to a resource plan. Each > rule can have a trigger expression and an action associated with it. Trigger > expressions are evaluated at runtime after configurable check interval, based > on which actions like killing a query, moving a query to different pool etc. > will get invoked. Simple rule could be something like > {code} > CREATE RULE slow_query IN resource_plan_name > WHEN execution_time_ms > 10000 > MOVE TO slow_queue > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)