[
https://issues.apache.org/jira/browse/CALCITE-1931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-1931:
-
Description: RANK, NTILE etc. functions should not always return INTEGER.
For example, RANK() and PERCENT_RANK() both return INTEGER. For RANK(), it
would be better to return BIGINT; for PERCENT_RANK(), we should actually return
DOUBLE or FLOAT since it is a percent value. There are other rank functions
that should return floating number instead of INTEGER. (was: For example,
rank() and percent_rank() both return INTEGER. For rank(), it would be better
to return BIGINT; for percent_rank(), we should actually return double or float
since it is a percent value. There are other rank functions that should return
floating number instead of integer.)
> Change the return type of RANK, NTILE and other aggregate functions
> ---
>
> Key: CALCITE-1931
> URL: https://issues.apache.org/jira/browse/CALCITE-1931
> Project: Calcite
> Issue Type: Bug
> Components: core
>Reporter: MinJi Kim
>Assignee: Julian Hyde
>
> RANK, NTILE etc. functions should not always return INTEGER. For example,
> RANK() and PERCENT_RANK() both return INTEGER. For RANK(), it would be
> better to return BIGINT; for PERCENT_RANK(), we should actually return DOUBLE
> or FLOAT since it is a percent value. There are other rank functions that
> should return floating number instead of INTEGER.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
