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

DISTINCT not pushed down to multisource sources

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 9.3
    • 9.2.2
    • Query Engine
    • None

    Description

      Simple DISTINCT queries do not push down DISTINCT to the underlying sources (SQL Server, in this case) of a multisource schema. Instead, all values are selected, and the sorting out is done in teiid.

      select distinct bic_status
      from account;
      

      Debug plan attached.

      This is an enhancement request to support partial distinct pushdown in the multi-source case.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            traivor Harold Campbell (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: