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

UNION pushdown

    XMLWordPrintable

Details

    Description

      I have SQL of the form
      SELECT a FROM (
      SELECT a FROM ds.t1 UNION
      SELECT a FROM ds.t2
      ) t

      The execution factory extends JDBCExecutionFactory and supports everything except row offset. It appears that the two unioned SELECTs are being executed as separate statements rather than the entire unioned set being pushed down to the datasource.

      Attached is plan

      Attachments

        1. plan.txt
          128 kB
        2. plan.txt
          125 kB

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            markaddleman_jira Mark Addleman (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: