phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ankit Singhal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-4540) Client side evaluation of group by Expression in projection gives erroneous result
Date Fri, 19 Jan 2018 11:36:00 GMT
Ankit Singhal created PHOENIX-4540:
--------------------------------------

             Summary: 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


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)

Mime
View raw message