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 Threaded View
HBase >> mail # user >> Fast scan with PrefixFilter?


Copy link to this message
-
Re: Fast scan with PrefixFilter?
Your start rowkey is the prefix it self.
Your end row key is the prefix +1. Increase the last byte by 1. I can send
you the increase function if you need.
No filter needed.

On Wednesday, January 15, 2014, Ramon Wang <[EMAIL PROTECTED]> wrote:

> Hi Folks
>
> We have a table with fixed pattern row key design, the format for the row
> key is YEAR_COUNTRY_randomNumber, for example:
>
> 20140101_EN_1
> 20140101_EN_2
> 20140101_EN_3
> 20140101_US_1
> 20140101_US_2
> 20140101_US_3
> ...
>
> Is there a way i can quickly get the data for "20140101_EN_*" by using Scan
> without scan the full table? I think we are probably going to use
> the PrefixFilter filter with the Scan object, but the problem is that we
> don't know the "startRow" for each scan, any ideas?
>
> Thanks
> Ramon
>
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