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)
