Details
-
Enhancement
-
Resolution: Done
-
Major
-
9.2.2
-
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.