Mailing-List: contact dev-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of
 ramkrishna.s.vasudevan@gmail.com designates 209.85.192.170 as permitted
 sender)
MIME-Version: 1.0
In-Reply-To: 
 <8E858C3A39F0D046B420FBA6F75448C02FA97214@szxeml513-mbs.china.huawei.com>
References: 
 <8E858C3A39F0D046B420FBA6F75448C02FA97188@szxeml513-mbs.china.huawei.com>
	<CAAT7Mkq0wv6oh_LJ6ioJm1rP9XU++T1GF-g66B57SGVtx0EFuw@mail.gmail.com>
	<8E858C3A39F0D046B420FBA6F75448C02FA971F6@szxeml513-mbs.china.huawei.com>
	<CAAT7Mkowv6nn7wOjVn=1aVophmO+5beX_x7bx_w2T0dwNiDtRA@mail.gmail.com>
	<8E858C3A39F0D046B420FBA6F75448C02FA97214@szxeml513-mbs.china.huawei.com>
Date: Fri, 4 Apr 2014 16:23:30 +0530
Message-ID: 
 <CAAT7Mkqq67Tc=qC-4uFWiU0Jjh5LZBVHvuYOa1pAK_i3ObzY6A@mail.gmail.com>
Subject: Re: Scan with SingleColumnValueFilterfilter giving wrong output
From: ramkrishna vasudevan <ramkrishna.s.vasudevan@gmail.com>
To: "dev@hbase.apache.org" <dev@hbase.apache.org>
Content-Type: multipart/alternative; boundary=047d7bf0e6cc12c19504f63554cd

--047d7bf0e6cc12c19504f63554cd
Content-Type: text/plain; charset=ISO-8859-1

There is something called Valuefilter.  Check its usage and see if it suits
you.

Regards
Ram


On Fri, Apr 4, 2014 at 4:17 PM, ashish singhi <ashish.singhi@huawei.com>wrote:

> >> Do you still get row6 for value1 even after setting filterIfMissing as
> true?
> No.
>
> Do we something like multi value column value filter ?
>
> -----Original Message-----
> From: ramkrishna vasudevan [mailto:ramkrishna.s.vasudevan@gmail.com]
> Sent: 04 April 2014 16:05
> To: dev@hbase.apache.org
> Subject: Re: Scan with SingleColumnValueFilterfilter giving wrong output
>
> >>But for column value 'value1' also I am getting one row i.e., row1
> >>with
> col1
> You should get only one row ie. row1 with col1.
> Do you still get row6 for value1 even after setting filterIfMissing as
> true?
>
> Regards
> Ram
>
>
> On Fri, Apr 4, 2014 at 3:50 PM, ashish singhi <ashish.singhi@huawei.com
> >wrote:
>
> > Hi Ram.
> >
> > Thanks for your time and explanation.
> > I tried by setting true to SingleColumnValueFilter.setFilterIfMissing
> > as you mentioned.
> >
> > It worked for column value 'value2' in output I got only row2 with col1.
> > But for column value 'value1' also I am getting one row i.e., row1
> > with col1. As you said " In your first result row6 should not be the
> > result (strictly if you want only value1 with col1). You can see that
> > it has col3 in the result."
> >
> > But I want is to find all the columns in the table having mentioned
> > column value. Can someone please tell me how to get it ?
> >
> > -----Original Message-----
> > From: ramkrishna vasudevan [mailto:ramkrishna.s.vasudevan@gmail.com]
> > Sent: 04 April 2014 15:20
> > To: dev@hbase.apache.org
> > Subject: Re: Scan with SingleColumnValueFilterfilter giving wrong
> > output
> >
> > Hi Ashish
> >
> > I think the behaviour is fine.  There is a property called
> > filterIfMissing in Single Columnvalue filter.  If you don't need a row
> > which does not have the given column and value in your query, then you
> should set that to true.
> > See SingleColumnValueFilter.setFilterIfMissing.
> > In your first result row6 should not be the result (strictly if you
> > want only value1 with col1). You can see that it has col3 in the result.
> >
> > In your second result too row6 falls under the same category.
> > If a row has more than one cell and if we have found the matching
> > cell, the following cells of that row will also be included in the
> > result.  I hope the same behavior is there in 0.94.11 also. (should be).
> >
> > Regards
> > Ram
> >
> >
> >
> > On Fri, Apr 4, 2014 at 2:37 PM, ashish singhi
> > <ashish.singhi@huawei.com
> > >wrote:
> >
> > > Hi all.
> > >
> > > I am using,
> > > HBase Version - 0.94.11
> > > Hadoop Version - 2.1.0
> > >
> > > I am trying to get columns having the specified value. So for that I
> > > am using org.apache.hadoop.hbase.filter.SingleColumnValueFilter class.
> > > But when I try to scan table to find columns with column value
> > > 'value2', I think I am not getting proper output.
> > >
> > > Can someone please tell me where I am wrong ?
> > >
> > > I have a simple hbase table with records.
> > > hbase(main):014:0> scan 'testTable'
> > > ROW                                                  COLUMN+CELL
> > > row1
> > >  column=colFammily1:col1, timestamp=1396586048561, value=value1
> > > row2
> > >  column=colFammily1:col1, timestamp=1396586054526, value=value2
> > > row2
> > >  column=colFammily1:col2, timestamp=1396585985022, value=testValue
> > > row3
> > >  column=colFammily1:col1, timestamp=1396586060989, value=value3
> > > row4
> > >  column=colFammily1:col1, timestamp=1396586066037, value=value4
> > > row5
> > >  column=colFammily1:col1, timestamp=1396586071842, value=value5
> > > row6
> > >  column=colFammily1:col3, timestamp=1396590405939, value=value1
> > > 6 row(s) in 0.0320 seconds
> > >
> > > First: When I executed scan command with column value 'value1' I got
> > > the proper output.
> > > hbase(main):023:0> scan 'testTable', {FILTER =>
> > > org.apache.hadoop.hbase.filter.SingleColumnValueFilter.new(org.apache.
> > > hadoop.hbase.util.Bytes.toBytes('colFammily1'),org.apache.hadoop.hba
> > > se
> > > .util.Bytes.toBytes('col1'),
> > >
> > org.apache.hadoop.hbase.filter.CompareFilter::CompareOp.valueOf('EQUAL
> > '),org.apache.hadoop.hbase.util.Bytes.toBytes('value1'))}
> > > ROW                                                  COLUMN+CELL
> > > row1
> > >  column=colFammily1:col1, timestamp=1396586048561, value=value1
> > > row6
> > >  column=colFammily1:col3, timestamp=1396590405939, value=value1
> > > 2 row(s) in 0.0160 seconds
> > >
> > > Second: When I tried same command with column value 'value2' the
> > > output seems to be incorrect.
> > > hbase(main):025:0> scan 'testTable', {FILTER =>
> > > org.apache.hadoop.hbase.filter.SingleColumnValueFilter.new(org.apache.
> > > hadoop.hbase.util.Bytes.toBytes('colFammily1'),org.apache.hadoop.hba
> > > se
> > > .util.Bytes.toBytes('col1'),
> > >
> > org.apache.hadoop.hbase.filter.CompareFilter::CompareOp.valueOf('EQUAL
> > '),org.apache.hadoop.hbase.util.Bytes.toBytes('value2'))}
> > > ROW                                                  COLUMN+CELL
> > > row2
> > >  column=colFammily1:col1, timestamp=1396586054526, value=value2
> > > row2
> > >  column=colFammily1:col2, timestamp=1396585985022, value=testValue
> > > row6
> > >  column=colFammily1:col3, timestamp=1396590405939, value=value1
> > > 2 row(s) in 0.0100 seconds
> > >
> > > I am not able to understand why I am getting row2 with col2 and row6
> > > in the output where in their column values are not 'value2'.
> > >
> > > Regards,
> > > Ashish
> > >
> >
>

--047d7bf0e6cc12c19504f63554cd--