[
https://issues.apache.org/jira/browse/PHOENIX-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15011754#comment-15011754
]
James Taylor commented on PHOENIX-2315:
---------------------------------------
The ordering of rows is controlled by ORDER BY. The order of expressions listed
in the GROUP BY shouldn't have an impact on ordering.
> 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)
