[teiid-issues] [JBoss JIRA] Updated: (TEIID-1735) RF: Add the ability to use DISTINCT in windowed aggregates in EDS
[
https://issues.jboss.org/browse/TEIID-1735?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-1735:
----------------------------------
Fix Version/s: 7.6
Affects Version/s: 7.5
This restriction was made because both SQL Server and Postgres lack support. We can add
support in Teiid with an additional capability check.
The existing logic would need adapted to handle distinct ordered over clauses as
performing a full pass sort would be too expensive.
RF: Add the ability to use DISTINCT in windowed aggregates in EDS
-----------------------------------------------------------------
Key: TEIID-1735
URL: https://issues.jboss.org/browse/TEIID-1735
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.5
Reporter: Debbie Steigner
Assignee: Steven Hawkins
Fix For: 7.6
According to the following page:
http://docs.jboss.org/teiid/7.5.0.Final/reference/en-US/html_single/#wind...
This states that "windowed aggregates may not use DISTINCT". I would like to
request that use of DISTINCT in aggregate functions be supported in a future release.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira