[ 
https://issues.apache.org/jira/browse/PHOENIX-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15339037#comment-15339037
 ] 

Hudson commented on PHOENIX-3005:
---------------------------------

SUCCESS: Integrated in Phoenix-master #1268 (See 
[https://builds.apache.org/job/Phoenix-master/1268/])
PHOENIX-3005 Fixes for COUNT(DISTINCT...) with DistinctPrefixFilter and (larsh: 
rev f840d558c41e3a948b921dfce47e91dee72b0250)
* 
phoenix-core/src/it/java/org/apache/phoenix/end2end/DistinctPrefixFilterIT.java
* phoenix-core/src/test/java/org/apache/phoenix/compile/QueryOptimizerTest.java
* 
phoenix-core/src/main/java/org/apache/phoenix/expression/function/DistinctCountAggregateFunction.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/GroupByCompiler.java


> Fixes for COUNT(DISTINCT...) with DistinctPrefixFilter and indexes
> ------------------------------------------------------------------
>
>                 Key: PHOENIX-3005
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3005
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Lars Hofhansl
>            Assignee: Lars Hofhansl
>             Fix For: 4.8.0
>
>         Attachments: 3005-v2.txt, 3005-wip-v1.txt, PHOENIX-3005_v1.patch
>
>
> It turns out that PHOENIX-2965 has some bugs with indexes:
> # COUNT(DISTINCT <indexed column>) does not use the DistinctPrefixFilter
> # Once an index is created COUNT(DISTINCT <pk-prefix>) is no longer using the 
> DistinctPrefixFilter
> This jira fixes both issues.
> Was:
> Currently the optimization in PHOENIX-258 is not used for DISTINCT index 
> scans. We should add that as well.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to