hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anoop Sam John <anoo...@huawei.com>
Subject RE: ValueFilter and VERSIONS
Date Fri, 18 Jan 2013 06:43:49 GMT

ValueFilter works only on the KVs not at a row level . So something similar is not possible.
Setting versions to 1 will make only one version (latest) version getting back to the client.
But the filtering is done prior to the versioning decision and filters will see all the version
values.

-Anoop-
________________________________________
From: Li, Min [mili@microstrategy.com]
Sent: Friday, January 18, 2013 12:00 PM
To: user@hbase.apache.org
Subject: RE: ValueFilter and VERSIONS

Hi Anoop,

Thanks for your reply. But I have to use value filter here, because in some of my use case,
I can't identify the qualifier.

Thanks,
Min

-----Original Message-----
From: Anoop Sam John [mailto:anoopsj@huawei.com]
Sent: Friday, January 18, 2013 2:28 PM
To: user@hbase.apache.org
Subject: RE: ValueFilter and VERSIONS

Can you make use of SingleColumnValueFilter.  In this you can specify whether the condition
to be checked only on the latest version or not.
SCVF#setLatestVersionOnly ( true)

-Anoop-
________________________________________
From: Li, Min [mili@microstrategy.com]
Sent: Friday, January 18, 2013 11:47 AM
To: user@hbase.apache.org
Subject: ValueFilter and VERSIONS

Hi all,

As you know, ValueFilter will filter data from all versions, so I create a table and indicate
it has only 1 version. However, the old version record still can be gotten by ValueFilter?
Does anyone know how to create a table with only one version record?

BTW, I am using hbase 0.92.1. Following is my testing commands:


hbase(main):016:0> create 'testUser',  {NAME => 'F', VERSIONS => 1}
0 row(s) in 1.0630 seconds

hbase(main):017:0> put 'testUser', '123, 'F:f', '3'
0 row(s) in 0.0120 seconds

hbase(main):018:0> put 'testUser', '123, 'F:f', '1'
0 row(s) in 0.0060 seconds

hbase(main):019:0> scan 'testUser'
ROW                                                COLUMN+CELL
 123                column=F:f, timestamp=1358489113213, value=1
1 row(s) in 0.0110 seconds

hbase(main):020:0> scan 'testUser',{FILTER => "(PrefixFilter ('123') AND ValueFilter
(>,'binary:1')"}
ROW                                                COLUMN+CELL
 123                column=F:f, timestamp=1358489110172, value=3
1 row(s) in 0.1790 seconds


Thanks,
Min
Mime
View raw message