Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3130

Project can be pushed below union all / union to improve performance

    Details

      Description

      A query such as

      Select a from 
      (select a, b, c, ..., union all select a, b, c, ...)
      

      will perform Union-All over all the specified columns on the two sides, despite the fact that only one column is asked for at the end. Ideally, we should perform ProjectPushDown rule for Union & Union-All to avoid them to generate results which will be discarded at the end.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vitalii Vitalii Diravka
                Reporter:
                seanhychu Sean Hsuan-Yi Chu
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: