[
https://issues.apache.org/jira/browse/PHOENIX-272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabriel Reid resolved PHOENIX-272.
----------------------------------
Resolution: Fixed
Bulk resolve of closed issues imported from GitHub. This status was reached by
first re-opening all closed imported issues and then resolving them in bulk.
> Make use of FuzzyRowFilter for predicates filtering the middle parts of a
> multi-part rowkey
> -------------------------------------------------------------------------------------------
>
> Key: PHOENIX-272
> URL: https://issues.apache.org/jira/browse/PHOENIX-272
> Project: Phoenix
> Issue Type: Task
> Reporter: Maryann Xue
>
> If a multi-part rowkey is defined as "part0:part1:part2", and the where
> clause is like "where part1 = 'xxx' and c1 = 'yyy'", we can take out the
> "part1 = 'xxx'" predicate and make it a FuzzyRowFilter in execution. Thus,
> instead of scanning the entire table, we get the benefit of passing over a
> bunch of rows that should be filtered out.
> The performance gain depends on the proportion of rowkeys that can be
> filtered by FuzzyRowFilter, but is usually very considerable in cases similar
> to the example listed above.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
