Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-15752

Optimize metadata only query that has an aggregate whose children are deterministic project or filter operators

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.1.0
    • SQL
    • None

    Description

      when query only use metadata (example: partition key), it can return results based on metadata without scaning files. Hive did it in HIVE-1003.
      design document:
      https://docs.google.com/document/d/1Bmi4-PkTaBQ0HVaGjIqa3eA12toKX52QaiUyhb6WQiM/edit?usp=sharing

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. SPARK-26709 OptimizeMetadataOnlyQuery does not correctly handle the files with zero record

          • Blocker - Blocks development and/or testing work, production could not run
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. SPARK-23523 Incorrect result caused by the rule OptimizeMetadataOnlyQuery

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

          Improvement - An improvement or enhancement to an existing feature or task. SPARK-12890 Spark SQL query related to only partition fields should not scan the whole data.

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          links to

          Pull request #13494 [Github] Pull Request #13494 (lianhuiwang)

          Activity

            People

              lianhuiwang Lianhui Wang
              lianhuiwang Lianhui Wang
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: