[
https://issues.apache.org/jira/browse/PHOENIX-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lars Hofhansl updated PHOENIX-3005:
-----------------------------------
Description:
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.
was:
It turns out that
Was:
Currently the optimization in PHOENIX-258 is not used for DISTINCT index scans.
We should add that as well.
> 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
> 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)
