Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-17481 LLAP workload management
  3. HIVE-17508

Implement global execution triggers based on counters

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.0.0
    • None

    Description

      Workload management can defined Triggers that are bound to a resource plan. Each trigger 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 execution trigger could be something like

      CREATE TRIGGER slow_query IN global
WHEN execution_time_ms > 10000
MOVE TO slow_queue

      Attachments

        1. HIVE-17508.13.patch
          130 kB
          Prasanth Jayachandran
        2. HIVE-17508.12.patch
          135 kB
          Prasanth Jayachandran
        3. HIVE-17508.11.patch
          135 kB
          Prasanth Jayachandran
        4. HIVE-17508.10.patch
          133 kB
          Prasanth Jayachandran
        5. HIVE-17508.9.patch
          142 kB
          Prasanth Jayachandran
        6. HIVE-17508.8.patch
          138 kB
          Prasanth Jayachandran
        7. HIVE-17508.7.patch
          131 kB
          Prasanth Jayachandran
        8. HIVE-17508.6.patch
          131 kB
          Prasanth Jayachandran
        9. HIVE-17508.5.patch
          102 kB
          Prasanth Jayachandran
        10. HIVE-17508.4.patch
          107 kB
          Prasanth Jayachandran
        11. HIVE-17508.3.patch
          83 kB
          Prasanth Jayachandran
        12. HIVE-17508.3.patch
          85 kB
          Prasanth Jayachandran
        13. HIVE-17508.2.patch
          59 kB
          Prasanth Jayachandran
        14. HIVE-17508.1.patch
          58 kB
          Prasanth Jayachandran
        15. HIVE-17508.WIP.2.patch
          55 kB
          Prasanth Jayachandran
        16. HIVE-17508.WIP.patch
          41 kB
          Prasanth Jayachandran

        Issue Links

          blocks

          Sub-task - The sub-task of the issue HIVE-17778 Add support for custom counters in trigger expression

          • Major - Major loss of function.
          • Closed
          is blocked by

          Sub-task - The sub-task of the issue HIVE-17637 Refactor WorkloadManager for accessing operations handles in service layer

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link RB

          Activity

            People

              prasanth_j Prasanth Jayachandran
              prasanth_j Prasanth Jayachandran
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: