Scan table with multiple rowkey filter in hbase

hbase row-key
Aashu picture Aashu · Aug 9, 2014 · Viewed 7.9k times · Source

I have tried with single row-key ,its working fine but i am unable to fetch multiple row-key scan.

scan 'LPV',{FILTER =>"(PrefixFilter('174','194')"}

getting error,find Filter to support scan multiple row key ranges but didnt find is it possible or not ? I want to fetch multiple records based on multiple row-keys. Any help,Thanks.

Answer

Arnon Rotem-Gal-Oz picture Arnon Rotem-Gal-Oz · Aug 10, 2014

You just need to OR two PrefixFilters as in

scan 'LPV',{FILTER =>"(PrefixFilter('174') OR PrefixFilter('194')"}

Related questions

How to delete all data from solr and hbase

How do I delete all data from solr by command? We are using solr with lily and hbase. How can I delete data from both hbase and solr? http://lucene.apache.org/solr/4_10_0/tutorial.html#Deleting+Data

Read More
When to use Hadoop, HBase, Hive and Pig?

What are the benefits of using either Hadoop or HBase or Hive ? From my understanding, HBase avoids using map-reduce and has a column oriented storage on top of HDFS. Hive is a sql-like interface for Hadoop and HBase. I would …

Read More
Hbase quickly count number of rows

Right now I implement row count over ResultScanner like this for (Result rs = scanner.next(); rs != null; rs = scanner.next()) { number++; } If data reaching millions time computing is large.I want to compute in real time that i don't want …

Read More