Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-1513 Support set operations
  3. TAJO-1525

Implement INTERSECT [ALL] physical operator

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.11.0
    • None
    • None

    Description

      As discussed in TAJO-1517,
      INTERSECT ALL needs new physical operator,
      which returns the exact number of overlapping rows between results of two query blocks.
      For example, when query1 returns

      1, 3, 3, 3
      

      while query2 returns

      3, 3
      

      query1 INTERSECT ALL query2 should return

      3, 3
      

      INTERSECT can be implemented by selecting distinct result of above physical operator.

      Attachments

        Issue Links

          Activity

            People

              sirpkt Keuntae Park
              sirpkt Keuntae Park
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: