Home | About | Sematext search-lucene.com search-hadoop.com
 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
>