[ 
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)

Reply via email to