[jira] [Resolved] (PHOENIX-272) Make use of FuzzyRowFilter for predicates filtering the middle parts of a multi-part rowkey

["Gabriel Reid (JIRA)" <ji...@apache.org>]

     [ 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)