[ 
https://issues.apache.org/jira/browse/PHOENIX-4315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Xinyi Yan reassigned PHOENIX-4315:
----------------------------------

    Assignee: Xinyi Yan

Currently, COALESCE supports only 2 arguments.

For instance, the GREATEST(expr1, expr2) is supported but GREATEST(expr1, 
expr2, expr3, ...) is not. Only implemented GREATEST for now, but if the list 
of arguments uses cases are needed from the open source community, We can do 
the optimization later.

If everyone is ok with this approach, I will create another patch for Least 
feature.

:)

> function Greatest/Least
> -----------------------
>
>                 Key: PHOENIX-4315
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4315
>             Project: Phoenix
>          Issue Type: New Feature
>            Reporter: Ethan Wang
>            Assignee: Xinyi Yan
>            Priority: Major
>         Attachments: PHOENIX-4315.patch
>
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> Resolve as the greatest value among a collection of projections.
> e.g.,
> Select greatest(A, B) from table  
> Select greatest(1,2) 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to