From dev-return-48614-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Fri Jan 19 12:41:06 2018 Return-Path: X-Original-To: archive-asf-public@eu.ponee.io Delivered-To: archive-asf-public@eu.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by mx-eu-01.ponee.io (Postfix) with ESMTP id 9C54A180670 for ; Fri, 19 Jan 2018 12:41:06 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 8CAF1160C27; Fri, 19 Jan 2018 11:41:06 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id D2281160C28 for ; Fri, 19 Jan 2018 12:41:05 +0100 (CET) Received: (qmail 43305 invoked by uid 500); 19 Jan 2018 11:41:04 -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 43029 invoked by uid 99); 19 Jan 2018 11:41:04 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 19 Jan 2018 11:41:04 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 62FB618096C for ; Fri, 19 Jan 2018 11:41:04 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -107.911 X-Spam-Level: X-Spam-Status: No, score=-107.911 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, KAM_ASCII_DIVIDERS=0.8, RCVD_IN_DNSWL_LOW=-0.7, SPF_PASS=-0.001, T_RP_MATCHES_RCVD=-0.01, 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 (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id fxdpj-rNWkWE for ; Fri, 19 Jan 2018 11:41:03 +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 8982F5F6C2 for ; Fri, 19 Jan 2018 11:41:02 +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 5409DE0F68 for ; Fri, 19 Jan 2018 11:41:01 +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 70249241C8 for ; Fri, 19 Jan 2018 11:41:00 +0000 (UTC) Date: Fri, 19 Jan 2018 11:41:00 +0000 (UTC) From: "Ankit Singhal (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (PHOENIX-4540) Client side evaluation of group by Expression in projection gives erroneous result 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-4540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-4540: ----------------------------------- Attachment: PHOENIX-4540_unittest.patch > Client side evaluation of group by Expression in projection gives erroneous result > ---------------------------------------------------------------------------------- > > Key: PHOENIX-4540 > URL: https://issues.apache.org/jira/browse/PHOENIX-4540 > Project: Phoenix > Issue Type: Bug > Reporter: Ankit Singhal > Priority: Major > Attachments: PHOENIX-4540_unittest.patch > > > If the columns involved in projected expression are not present in "group by" clause, the client evaluation of the same expression will give an erroneous result because of the absence of involved column value. > Following queries will produce wrong result > >select round(k/v,0) x from round_test group by x,v > >select k/v x from round_test group by x,v > but query runs fine if we add all columns so that client expression can be evaluated > >select round(k/v,0) x from round_test group by x,k,v //will produce right result > >select k/v x from round_test group by x,k,v; > Why we need to re-evaluate the expression here, can't we use the same result evaluated at server side during the "group by" > thoughts [~jamestaylor]? -- This message was sent by Atlassian JIRA (v7.6.3#76005)