phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xinyi Yan (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (PHOENIX-4315) function Greatest/Least
Date Thu, 07 Mar 2019 03:53:00 GMT

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

Mime
View raw message