phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2965) Use DistinctPrefixFilter logic for COUNT(DISTINCT ...) and COUNT(...) GROUP BY
Date Thu, 09 Jun 2016 22:00:22 GMT

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

Hudson commented on PHOENIX-2965:
---------------------------------

FAILURE: Integrated in Phoenix-master #1249 (See [https://builds.apache.org/job/Phoenix-master/1249/])
PHOENIX-2965 Use DistinctPrefixFilter logic for COUNT(DISTINCT ...) and (larsh: rev e7e8e130b4ec84b32ed507201c1a00939f1d3b7c)
* 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/main/java/org/apache/phoenix/compile/GroupByCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/OrderPreservingTracker.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-v2.txt, 2965-v3.txt, 2965-v4.txt, 2965-v5.txt, 2965-v6.txt,
2965.txt
>
>
> 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)

Mime
View raw message