Do you see the same slowness scanning regions with FilterList outside coprocessor ?
Thanks On Jan 17, 2014, at 5:24 PM, "[email protected]" <[email protected]> wrote: > Hi, > > I have tried. > For a talbe with about 600 million rowkey, just pass a single > QualifierFilter, it can get the result quickly. > But when i add the SingleColumnValueFilter with FilterList, it becoumes very > slow and i can't stand it. > > I think i can write my own custumed aggregation client. Is there any example > or user guide about how to write custumed aggregation client using > coprocessor? > > Thanks, > Lei > > > > > [email protected] > > From: Ted Yu > Date: 2014-01-17 18:03 > To: [email protected] > CC: user > Subject: Re: How to quickly count the rows that meet several conditions using > hbase coprocessor > Take a look at > http://hbase.apache.org/0.94/apidocs/org/apache/hadoop/hbase/client/coprocessor/AggregationClient.html#rowCount(byte[],%20org.apache.hadoop.hbase.coprocessor.ColumnInterpreter,%20org.apache.hadoop.hbase.client.Scan) > > You can pass custom filter through Scan parameter. > > Cheers > > On Jan 16, 2014, at 11:58 PM, "[email protected]" <[email protected]> > wrote: > >> Hi, >> >> I know that hbase copocessor provides a quick way to count the rows of a >> table. >> But how can i count the rows that meet several conditions. >> >> Take this for example. >> I have a hbase table with one column family, several columns. I want to >> caculate the number of rows that meet 3 conditions: >> has column1 >> has column2 >> has column3 and the value of column3 satisfy a regular expression >> >> Thans, >> Lei >> >> >> >> [email protected]
