Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-1577

Add test cases to verify join plans

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.11.0
    • Component/s: Unit Test
    • Labels:
      None

      Description

      We are lacking test cases to verify query plans even though they directly affect to query processing performance. This is important especially for join queries because their plans can be changed while optimizing join order that affects to performance significantly. So, we need to verify the optimal join plan first.

      There can be some approaches to test query plans. Here are some candidates what I consider.

      • Adding a special class that verifies query plans while traversing it.
      • Verifying the result of EXPLAIN query.

      I think that the second approach looks good. Here are some reasons.

      • Easy to implement. It's just string match.
      • Easy to verify both logical plan and global plan without adding any special classes to traverse query plan.
      • This is the most important reason. With the second approach, we can guarantee that our query planner is deterministic.

        Attachments

        1. fix_plan_preprocessor.patch
          8 kB
          Jihoon Son
        2. TAJO-1577_2.patch
          3.52 MB
          Jihoon Son
        3. TAJO-1577.patch
          3.75 MB
          Jihoon Son

          Issue Links

            Activity

              People

              • Assignee:
                navis Navis
                Reporter:
                jihoonson Jihoon Son
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: