Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-8022

Add cardinality checks to PlannerTest

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: Impala 3.1.0
    • Fix Version/s: None
    • Component/s: Frontend
    • Labels:
      None
    • Epic Color:
      ghx-label-4

      Description

      IMPALA-8021 suggests that we add cardinality to the standard EXPLAIN output. When we do so, the cardinality will appear in the plans generated by PlannerTest. We could just ignore the numbers, as we do for other derived values. Or, we could use this opportunity to verify the expected cardinalities.

      The expected cardinality is a critical number when planning queries: we decide join planning based on that number (sometimes multiplied by row width.) To prevent regressions, we want to verify that we've not changed the cardinality estimates except by design.

      Since cardinality estimates may vary a bit, do a range-based comparison, accepting as valid any value within 5% of the expected value. (Except for zero, if zero is expected, the actual estimate must also be zero.)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Paul.Rogers Paul Rogers
                Reporter:
                Paul.Rogers Paul Rogers
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: