Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1656

Add pushdown support for grouping expression over a UNION

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 7.4.1, 7.5
    • 7.1.1, 7.4
    • Query Engine
    • None

      1) User has created a view MyView containing UNION all of two other views, eg "SELECT * FROM View1 UNION ALL SELECT * FROM View 2".
      2) Then a user query containing a searched CASE type expression is submitted against the view, eg "SELECT max(col) FROM MyView group by CASE WHEN StringNum IS NULL THEN 0 ELSE 1 END"
      3) With current planner the CASE expression / group by is not pushed down to the individual sources. The enhancement request is to allow the pushdown.

            pnittel_jira Paul Nittel (Inactive)
            mdrillin1@redhat.com Mark Drilling (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: