[
https://issues.apache.org/jira/browse/PHOENIX-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15000065#comment-15000065
]
James Taylor commented on PHOENIX-2315:
---------------------------------------
bq. Why the sorting of the group by fields is needed?
Because it gives predictable ordering between {{GROUP BY a,b}} and {{GROUP BY
b,a}}
Would you be up for taking a crack at fixing with the sorting we do?
> Group by fields of primary key columns together with non-primary key columns
> can give wrong result
> --------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-2315
> URL: https://issues.apache.org/jira/browse/PHOENIX-2315
> Project: Phoenix
> Issue Type: Bug
> Reporter: Alicia Ying Shu
> Assignee: Alicia Ying Shu
>
> create table tgb_counter(tgb_id integer NOT NULL,utc_date_epoch integer NOT
> NULL,tgb_name varchar(40),ack_success_count integer,ack_success_one_ack_count
> integer, CONSTRAINT pk_tgb_counter PRIMARY KEY(tgb_id, utc_date_epoch));
> SELECT tgb_id, tgb_name, (utc_date_epoch/10)*10 AS
> utc_epoch_hour,SUM(ack_success_count + ack_success_one_ack_count) AS
> ack_tx_sum FROM tgb_counter GROUP BY tgb_id, tgb_name, utc_epoch_hour;
> tgb_name returns NULL.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
