[ https://issues.apache.org/jira/browse/PHOENIX-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15326570#comment-15326570 ]
Hudson commented on PHOENIX-2965: --------------------------------- FAILURE: Integrated in Phoenix-master #1256 (See [https://builds.apache.org/job/Phoenix-master/1256/]) PHOENIX-2965 Use DistinctPrefixFilter logic for COUNT(DISTINCT ...) and (larsh: rev 951dd7a788d87efbe238ff6dec996d9d8acc4211) * phoenix-core/src/main/java/org/apache/phoenix/iterate/BaseResultIterators.java * phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java * phoenix-core/src/test/java/org/apache/phoenix/compile/QueryCompilerTest.java * phoenix-core/src/main/java/org/apache/phoenix/compile/GroupByCompiler.java > Use DistinctPrefixFilter logic for COUNT(DISTINCT ...) and COUNT(...) GROUP BY > ------------------------------------------------------------------------------ > > Key: PHOENIX-2965 > URL: https://issues.apache.org/jira/browse/PHOENIX-2965 > Project: Phoenix > Issue Type: Sub-task > Reporter: Lars Hofhansl > Assignee: Lars Hofhansl > Fix For: 4.8.0 > > Attachments: 2965-v10.txt, 2965-v11.txt, 2965-v12.txt, 2965-v13.txt, > 2965-v14.txt, 2965-v2.txt, 2965-v3.txt, 2965-v4.txt, 2965-v5.txt, > 2965-v6.txt, 2965-v7.txt, 2965-v8.txt, 2965-v9.txt, 2965.txt, > PHOENIX-2965_wip.patch > > > Parent uses skip scanning to optimize DISTINCT and certain GROUP BY > operations along the row key. > COUNT queries are optimized differently, could be sped up significantly as > well. > [~giacomotaylor], I might need to help into where COUNT(DISTINCT) queries are > planned and optimized. -- This message was sent by Atlassian JIRA (v6.3.4#6332)