Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-2247

Simplify AND and OR conditions using predicates

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.17.0
    • None
    • None

    Description

      Simplify expressions like: 

      a = 1 AND (a = 1 OR a = 2)

      to 

      a = 1

      Conditions to apply will be:

      • in an AND condition there exists a comparison(c) and an OR (o)
      • o and c only reference 1 variable

      See HIVE-19097 for more info.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-3192 Simplification may weaken OR conditions containing inequalities

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

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-2314 Verify RexNode transformations by evaluating before and after expressions against sample values

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. HIVE-19097 related equals and in operators may cause inaccurate stats estimations

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-2326 Generalize p(x) IS TRUE/FALSE/UNKNOWN handling in RexSimplify

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-2257 Combination of predicates can be proved to be always true

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

          Web Link PR

          Web Link PR including OR

          Activity

            People

              kgyrtkirk Zoltan Haindrich
              kgyrtkirk Zoltan Haindrich
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: