Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of yuzhihong@gmail.com designates
 209.85.215.52 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <1371813553460-4046726.post@n3.nabble.com>
References: <1371813553460-4046726.post@n3.nabble.com>
Date: Mon, 24 Jun 2013 08:51:14 +0800
Message-ID: 
 <CALte62xQY5LP8rJPmmfuFUiJMgt=oeubJgSPLeibJKfRJJTE_Q@mail.gmail.com>
Subject: Re: HBase Filterlist hierarchy not working
From: Ted Yu <yuzhihong@gmail.com>
To: user@hbase.apache.org
Content-Type: multipart/alternative; boundary=001a113369743e13b204dfdbcfbb

--001a113369743e13b204dfdbcfbb
Content-Type: text/plain; charset=ISO-8859-1

Can you tell us which HBase version you are using ?

Thanks

On Fri, Jun 21, 2013 at 7:19 PM, sandesh <sandeshpai@gmail.com> wrote:

> Hi,
>
> Filter List with multiple filters is not working for us.
>
> We have a table 'country_details' with family 'country' having  columns
> with
> prefix 'AGE' and 'SALARY'.
>
> Data is inserted as shown below.
>
> We need to get following rows and columns based on filters
>
>    'SRILANKA' if 'AGE' prefix column has value >= 30
> OR 'INDIA' if 'AGE' prefix column has value >= 20
> OR 'JAPAN' if 'SALARY' prefix column has value >= 3000
>
> We have wriiten following filter criteria for scan
>
> scan 'country_details', { FILTER => "(
> ( RowFilter(=,'binary:SRILANKA') AND (ColumnPrefixFilter('AGE') AND
> ValueFilter(>=,'binary:30')) )
> OR
> ( RowFilter(=,'binary:INDIA') AND (ColumnPrefixFilter('AGE') AND
> ValueFilter(>=,'binary:20')) )
> OR
> ( RowFilter(=,'binary:JAPAN') AND (ColumnPrefixFilter('SALARY') AND
> ValueFilter(>=,'binary:3000')) )
> )" }
>
> But we are not getting correct result (In Bold. i.e. "SRILANKA
> column=country:AGE:123457, timestamp=1371811958816, value=*23* " ). Is it
> something wrong with filters we have used or this kind of filters cannot be
> used ?
>
>
>
>
> create 'country_details', 'country'
>
>
> put 'country_details','INDIA','country:AGE:123456','34';
> put 'country_details','INDIA','country:AGE:123451','32';
> put 'country_details','INDIA','country:AGE:123452','23';
> put 'country_details','INDIA','country:AGE:123453','24';
> put 'country_details','INDIA','country:AGE:123454','30';
>
> put 'country_details','SRILANKA','country:AGE:123455','30';
> put 'country_details','SRILANKA','country:AGE:123457','23';
> put 'country_details','SRILANKA','country:AGE:123458','34';
> put 'country_details','SRILANKA','country:AGE:123459','18';
> put 'country_details','SRILANKA','country:AGE:123450','19';
>
> put 'country_details','JAPAN','country:AGE:1234565','23';
> put 'country_details','JAPAN','country:AGE:1234557','25';
> put 'country_details','JAPAN','country:AGE:1234578','35';
> put 'country_details','JAPAN','country:AGE:1234559','37';
> put 'country_details','JAPAN','country:AGE:1234570','19';
>
> put 'country_details','JAPAN','country:SALARY:1234565','8000';
> put 'country_details','JAPAN','country:SALARY:1234557','2300';
> put 'country_details','JAPAN','country:SALARY:1234578','3400';
> put 'country_details','JAPAN','country:SALARY:1234559','4500';
> put 'country_details','JAPAN','country:SALARY:1234570','1900';
>
> hbase(main):075:0> scan 'country_details', { FILTER => "(  (
> RowFilter(=,'binary:SRILANKA') AND (ColumnPrefixFilter('AGE') AND
> ValueFilter(>=,'binary:30')) )  OR ( RowFilter(=,'binary:INDIA') AND
> (ColumnPrefixFilter('AGE') AND ValueFilter(>=,'binary:20')) ) OR (
> RowFilter(=,'binary:JAPAN') AND (ColumnPrefixFilter('SALARY') AND
> ValueFilter(>=,'binary:3000')) ) )" }
>
> ROW                                        COLUMN+CELL
>  INDIA                                     column=country:AGE:123451,
> timestamp=1371811958805, value=32
>  INDIA                                     column=country:AGE:123452,
> timestamp=1371811958808, value=23
>  INDIA                                     column=country:AGE:123453,
> timestamp=1371811958810, value=24
>  INDIA                                     column=country:AGE:123454,
> timestamp=1371811958812, value=30
>  INDIA                                     column=country:AGE:123456,
> timestamp=1371811958801, value=34
>  JAPAN                                     column=country:SALARY:1234559,
> timestamp=1371811958883, value=4500
>  JAPAN                                     column=country:SALARY:1234565,
> timestamp=1371811958874, value=8000
>  JAPAN                                     column=country:SALARY:1234578,
> timestamp=1371811958880, value=3400
>  SRILANKA                                  column=country:AGE:123455,
> timestamp=1371811958814, value=30
> * SRILANKA                                  column=country:AGE:123457,
> timestamp=1371811958816, value=23   *
>  SRILANKA                                  column=country:AGE:123458,
> timestamp=1371811958818, value=34
> 3 row(s) in 0.0350 seconds
>
>
>
> --
> View this message in context:
> http://apache-hbase.679495.n3.nabble.com/HBase-Filterlist-hierarchy-not-working-tp4046726.html
> Sent from the HBase User mailing list archive at Nabble.com.
>

--001a113369743e13b204dfdbcfbb--