[teiid-issues] [JBoss JIRA] (TEIID-5459) Support for large counts/ranks
Steven Hawkins (Jira)
issues at jboss.org
Tue Oct 2 17:19:00 EDT 2018
[ https://issues.jboss.org/browse/TEIID-5459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-5459.
-----------------------------------
Resolution: Done
The initial work focuses solely on the functions with integer return values - rank, dense_rank, and row_number. Additional work would be needed to allow the inner working of cume_dist and percent_rank to use long instead of integer - that can be worked later if it becomes an issue. COUNT_BIG was introduced, but is generally pushed as COUNT instead.
> Support for large counts/ranks
> ------------------------------
>
> Key: TEIID-5459
> URL: https://issues.jboss.org/browse/TEIID-5459
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 11.2
>
>
> Most databases implement analytical ranks/row_number as returning bigint - regardless of what type count returns. MS SQL introduced BIG_COUNT, and Postgresql switched everything to bigint in 7.2.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
More information about the teiid-issues
mailing list