[ https://issues.apache.org/jira/browse/PHOENIX-4077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16121128#comment-16121128 ]
jifei_yang commented on PHOENIX-4077: ------------------------------------- E.g,the table statement is as follows: {code:java} CREATE TABLE IF NOT EXISTS PH_HOTDOMAIN_APP ( CREATETIME VARCHAR(23), DOMAINID BIGINT NOT NULL, DOMAIN VARCHAR(128) NOT NULL, CDNNETID VARCHAR NOT NULL, SRCIP BIGINT NOT NULL, DOMAINFIRSTTIME VARCHAR(23) NOT NULL, DOMAINACTIVENESS BIGINT NOT NULL CONSTRAINT PH_HOTIP_APP_PK PRIMARY KEY( DOMAINID, DOMAIN, CDNNETID, SRCIP, DOMAINFIRSTTIME, DOMAINACTIVENESS ) ) SALT_BUCKETS = 30, COMPRESSION='snappy', MAXVERSIONS=1, BLOCKCACHE=false, BLOOMFILTERTYPE='ROW' ; {code} Check for phrases: (1)use DOMAIN and DOMAINID {code:java} select DOMAIN,DOMAINID,MIN(DOMAINFIRSTTIME) as DOMAINFIRSTTIME,SUM(DOMAINACTIVENESS) as DOMAINACTIVENESS from PH_HOTDOMAIN_APP where CREATETIME='2017-08-09' and instr(CDNNETID,'a1a') >0 group by DOMAIN,DOMAINID ; {code} (2)use DOMAINID and DOMAIN {code:java} select DOMAIN,DOMAINID,MIN(DOMAINFIRSTTIME) as DOMAINFIRSTTIME,SUM(DOMAINACTIVENESS) as DOMAINACTIVENESS from PH_HOTDOMAIN_APP where CREATETIME='2017-08-09' and instr(CDNNETID,'a1a') >0 group by DOMAINID,DOMAIN ; {code} The result of the output is not the same! {noformat} 0: jdbc:phoenix:localhost:2181:/hbase03> select DOMAIN,DOMAINID,MIN(DOMAINFIRSTTIME) as DOMAINFIRSTTIME,SUM(DOMAINACTIVENESS) as DOMAINACTIVENESS from PH_HOTDOMAIN_APP where CREATETIME='2017-08-09' and instr(CDNNETID,'a1a') >0 group by DOMAIN,DOMAINID ; +--------------------------+-----------+--------------------------+-------------------+ | DOMAIN | DOMAINID | DOMAINFIRSTTIME | DOMAINACTIVENESS | +--------------------------+-----------+--------------------------+-------------------+ | mvvideo2.meitudata.com | 1 | 2017-08-09 00:00:00.265 | 148713 | | mvvideo4.meitudata.com | 3 | 2017-08-09 00:00:00.406 | 74485 | | www.test.com | 2 | 2017-08-09 00:00:00.846 | 74228 | | mvvideo4.meitudata.com | 3 | 2017-08-09 00:00:00.979 | 74229 | | www.test.com | 2 | 2017-08-09 00:00:00.269 | 74485 | | mvvideo10.meitudata.com | 4 | 2017-08-09 00:00:00.412 | 148714 | +--------------------------+-----------+--------------------------+-------------------+ 6 rows selected (0.093 seconds) 0: jdbc:phoenix:localhost:2181:/hbase03> select DOMAIN,DOMAINID,MIN(DOMAINFIRSTTIME) as DOMAINFIRSTTIME,SUM(DOMAINACTIVENESS) as DOMAINACTIVENESS from PH_HOTDOMAIN_APP where CREATETIME='2017-08-09' and instr(CDNNETID,'a1a') >0 group by DOMAINID,DOMAIN ; +--------------------------+-----------+--------------------------+-------------------+ | DOMAIN | DOMAINID | DOMAINFIRSTTIME | DOMAINACTIVENESS | +--------------------------+-----------+--------------------------+-------------------+ | mvvideo2.meitudata.com | 1 | 2017-08-09 00:00:00.265 | 148713 | | www.test.com | 2 | 2017-08-09 00:00:00.269 | 148713 | | mvvideo4.meitudata.com | 3 | 2017-08-09 00:00:00.406 | 148714 | | mvvideo10.meitudata.com | 4 | 2017-08-09 00:00:00.412 | 148714 | +--------------------------+-----------+--------------------------+-------------------+ {noformat} > Why is the order of the grouping fields affecting the results of the query? > --------------------------------------------------------------------------- > > Key: PHOENIX-4077 > URL: https://issues.apache.org/jira/browse/PHOENIX-4077 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.11.0 > Reporter: jifei_yang > Fix For: 4.8.0, 4.11.0 > > > When I use the 'group by ' group query, the order of the grouping fields > affects the output. Why is this? -- This message was sent by Atlassian JIRA (v6.4.14#64029)