[teiid-issues] [JBoss JIRA] (TEIID-4865) DISTINCT not pushed down to multisource sources
Steven Hawkins (JIRA)
issues at jboss.org
Mon Apr 17 19:41:00 EDT 2017
[ https://issues.jboss.org/browse/TEIID-4865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13394151#comment-13394151 ]
Steven Hawkins commented on TEIID-4865:
---------------------------------------
Is bic_status the partitioning column? If not, then we'll have to process the distinct in the Teiid layer.
> DISTINCT not pushed down to multisource sources
> -----------------------------------------------
>
> Key: TEIID-4865
> URL: https://issues.jboss.org/browse/TEIID-4865
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 9.2.2
> Reporter: Harold Campbell
> Assignee: Steven Hawkins
> Attachments: DEBUG_LOG
>
>
> 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.
> {noformat}
> select distinct bic_status
> from account;
> {noformat}
> Debug plan attached.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
More information about the teiid-issues
mailing list