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 EFDAB1054F for ; Fri, 11 Oct 2013 05:57:48 +0000 (UTC) Received: (qmail 45797 invoked by uid 500); 11 Oct 2013 05:57:44 -0000 Delivered-To: apmail-hbase-issues-archive@hbase.apache.org Received: (qmail 45756 invoked by uid 500); 11 Oct 2013 05:57:43 -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 45722 invoked by uid 99); 11 Oct 2013 05:57:42 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Oct 2013 05:57:42 +0000 Date: Fri, 11 Oct 2013 05:57:42 +0000 (UTC) From: "Deepa Remesh (JIRA)" To: issues@hbase.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (HBASE-9747) PrefixFilter with OR condition gives wrong results MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Deepa Remesh created HBASE-9747: ----------------------------------- Summary: PrefixFilter with OR condition gives wrong results Key: HBASE-9747 URL: https://issues.apache.org/jira/browse/HBASE-9747 Project: HBase Issue Type: Bug Components: Filters Affects Versions: 0.94.9 Reporter: Deepa Remesh PrefixFilter when used with a SingleColumnValueFilter with an OR condition gives wrong results. In below example, each filter when evaluated separately gives 1 row each. The OR condition with the two filters gives 3 rows instead of 2. Repro below: create 't1', 'f1' put 't1','a1','f1:q2','111' put 't1','b1','f1:q1','112' put 't1','c1','f1:q1','113' hbase(main):020:0> scan 't1', {FILTER => "PrefixFilter ('b') OR SingleColumnValueFilter('f1', 'q1', =, 'binary:113')"} ROW COLUMN+CELL a1 column=f1:q2, timestamp=1381468905492, value=111 b1 column=f1:q1, timestamp=1381468905518, value=112 c1 column=f1:q1, timestamp=1381468905549, value=113 3 row(s) in 0.1020 seconds hbase(main):021:0> scan 't1', {FILTER => "PrefixFilter ('b')"} ROW COLUMN+CELL b1 column=f1:q1, timestamp=1381468905518, value=112 1 row(s) in 0.0150 seconds hbase(main):002:0> scan 't1', {FILTER => "SingleColumnValueFilter('f1', 'q1', =, 'binary:113')"} ROW COLUMN+CELL c1 column=f1:q1, timestamp=1381469178679, value=113 1 row(s) in 0.0140 seconds -- This message was sent by Atlassian JIRA (v6.1#6144)