You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Alicia Ying Shu (JIRA)" <ji...@apache.org> on 2015/10/08 02:06:26 UTC
[jira] [Created] (PHOENIX-2315) Group by fields of primary key
columns together with non-primary key columns can give wrong result
Alicia Ying Shu created PHOENIX-2315:
----------------------------------------
Summary: 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)