hbase-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lars Hofhansl (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HBASE-9747) PrefixFilter with OR condition gives wrong results
Date Fri, 18 Oct 2013 19:43:43 GMT

    [ https://issues.apache.org/jira/browse/HBASE-9747?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13799440#comment-13799440
] 

Lars Hofhansl commented on HBASE-9747:
--------------------------------------

Committed the tests as well. Thanks again [~adityakishore].

> 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.95.2, 0.94.9
>            Reporter: Deepa Remesh
>            Assignee: Aditya Kishore
>             Fix For: 0.98.0, 0.94.13, 0.96.1
>
>         Attachments: HBASE-9747_0.94.patch, HBASE-9747.patch, HBASE-9747_test_0.94.patch,
HBASE-9747_test.patch
>
>
> 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)

Mime
View raw message