From dev-return-55687-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Thu Mar 7 03:53:04 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 0937A180656 for ; Thu, 7 Mar 2019 04:53:03 +0100 (CET) Received: (qmail 90225 invoked by uid 500); 7 Mar 2019 03:53:02 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 90214 invoked by uid 99); 7 Mar 2019 03:53:02 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Mar 2019 03:53:02 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 64745C036D for ; Thu, 7 Mar 2019 03:53:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -110.301 X-Spam-Level: X-Spam-Status: No, score=-110.301 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id B-yEA25Dj_YZ for ; Thu, 7 Mar 2019 03:53:01 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 1219161115 for ; Thu, 7 Mar 2019 03:53:01 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 67D9DE27D5 for ; Thu, 7 Mar 2019 03:53:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 200252576B for ; Thu, 7 Mar 2019 03:53:00 +0000 (UTC) Date: Thu, 7 Mar 2019 03:53:00 +0000 (UTC) From: "Xinyi Yan (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Assigned] (PHOENIX-4315) function Greatest/Least MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ 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)