Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-12603

Add config to block queries that scan > N number of partitions

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • 2.0.0
    • None
    • Metastore, Query Planning
    • None

    Description

      Strict mode is useful for blocking queries that load all partitions, but it's still possible to put significant load on the HMS for queries that scan a large number of partitions. It would be useful to add a config provide a hard limit to the number of partitions scanned by a query.

      Attachments

        Issue Links

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. HIVE-6492 limit partition number involved in a table scan

          • Major - Major loss of function.
          • Resolved
          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-9499 hive.limit.query.max.table.partition makes queries fail on non-partitioned tables

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              lskuff Lenni Kuff
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: