Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
HBase >> mail # user >> ValueFilter and VERSIONS


+
Li, Min 2013-01-18, 06:17
+
Anoop Sam John 2013-01-18, 06:27
+
Li, Min 2013-01-18, 06:30
+
Anoop Sam John 2013-01-18, 06:43
Copy link to this message
-
RE: ValueFilter and VERSIONS
Thanks for your explanation.

Min

-----Original Message-----
From: Anoop Sam John [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2013 2:44 PM
To: [EMAIL PROTECTED]
Subject: RE: ValueFilter and VERSIONS
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 [[EMAIL PROTECTED]]
Sent: Friday, January 18, 2013 12:00 PM
To: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2013 2:28 PM
To: [EMAIL PROTECTED]
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 [[EMAIL PROTECTED]]
Sent: Friday, January 18, 2013 11:47 AM
To: [EMAIL PROTECTED]
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB