Return-Path: X-Original-To: apmail-hbase-issues-archive@www.apache.org Delivered-To: apmail-hbase-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D94C8DD25 for ; Wed, 8 Aug 2012 15:12:21 +0000 (UTC) Received: (qmail 65769 invoked by uid 500); 8 Aug 2012 15:12:21 -0000 Delivered-To: apmail-hbase-issues-archive@hbase.apache.org Received: (qmail 65686 invoked by uid 500); 8 Aug 2012 15:12:21 -0000 Mailing-List: contact issues-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list issues@hbase.apache.org Received: (qmail 65515 invoked by uid 99); 8 Aug 2012 15:12:21 -0000 Received: from issues-vm.apache.org (HELO issues-vm) (140.211.11.160) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Aug 2012 15:12:20 +0000 Received: from isssues-vm.apache.org (localhost [127.0.0.1]) by issues-vm (Postfix) with ESMTP id AAE861427FB for ; Wed, 8 Aug 2012 15:12:20 +0000 (UTC) Date: Wed, 8 Aug 2012 15:12:20 +0000 (UTC) From: "Alex Baranau (JIRA)" To: issues@hbase.apache.org Message-ID: <1031726379.362.1344438740704.JavaMail.jiratomcat@issues-vm> In-Reply-To: <937954933.12244.1344031022416.JavaMail.jiratomcat@issues-vm> Subject: [jira] [Updated] (HBASE-6509) Implement fast-forwarding FuzzyRowFilter to allow filtering rows e.g. by "???alex?b" MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HBASE-6509?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alex Baranau updated HBASE-6509: -------------------------------- Resolution: Fixed Status: Resolved (was: Patch Available) patch committed, marking as resolved. Thanx Ted, Jon! > Implement fast-forwarding FuzzyRowFilter to allow filtering rows e.g. by "???alex?b" > ------------------------------------------------------------------------------------ > > Key: HBASE-6509 > URL: https://issues.apache.org/jira/browse/HBASE-6509 > Project: HBase > Issue Type: New Feature > Components: filters > Reporter: Alex Baranau > Assignee: Alex Baranau > Priority: Minor > Fix For: 0.96.0 > > Attachments: HBASE-6509.patch, HBASE-6509_1.patch, HBASE-6509_2.patch, HBASE-6509_3.patch > > > Implement fuzzy row key filter to allow fetching records e.g. by this criteria: "???alex?b". > This seems to be very useful as an alternative to select records by row keys by specifying their part which is not prefix part. Due to fast-forwarding nature of the filter in many situations this helps to avoid heavy full-table scans. > This is especially effective when you have composite row key and (some of) its parts has fixed length. E.g. with the key of format userId_actionId_time, given that userId and actionId length is fixed, one can select user actions of specific type using fuzzy row key by specifying mask "????_myaction". Given fast-forwarding nature of filter, this will usually work much faster than doing whole table scan with any of the existing server-side filters. > In many cases this can work as secondary-indexing alternative. > Many times users implement it as a custom filter and many times they just don' know this is possible. Let's add it to the common codebase. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira