Combining PageFilter gives inconsistent number of rows

[Eko Susilo <ek...@gmail.com>]

Hi All,



I have problems when combining PageFilter with other filters. I am
combining SingleColumnValueFilter, KeyOnlyFilter, and PageFilter.

Scan returns different total number of row when pageFilter is present; the
number of row without page filter is greater. Furthermore, the order I
specify these filter in filter list also changes the number of returned
rows.



Anyone have had similar experience?



Thanks

-- 
Best Regards,
Eko Susilo

Re: Combining PageFilter gives inconsistent number of rows

[Anoop John <an...@gmail.com>]

Can u paste code how u make the FilterList?
I think you want to use MUST_PASS_ALL op in FL.

Ya the order of passing filters in FL can matter.

In your query case, you have to pass filter as  SCVF, KeyOnlyF, PageFilter.
The PageFilter must come at the end.

Any filter working scope is within one scanner at server end mean
within one Region scope.  So the Paging number guarantee is within one
region.  When u have many regions there is chance that from diff
regions u get diff numbers and so at client end.



-Anoop-

On Thu, Jun 9, 2016 at 7:36 PM, Ted Yu <yu...@gmail.com> wrote:
> Which version of hbase are you using ?
>
> Is it possible to come up with unit test that shows what you observed ?
>
> There is already coverage in existing unit tests, e.g. TestFilterList which
> you can use as template.
>
> Thanks
>
> On Thu, Jun 9, 2016 at 3:41 AM, Eko Susilo <ek...@gmail.com>
> wrote:
>
>> Hi All,
>>
>>
>>
>> I have problems when combining PageFilter with other filters. I am
>> combining SingleColumnValueFilter, KeyOnlyFilter, and PageFilter.
>>
>> Scan returns different total number of row when pageFilter is present; the
>> number of row without page filter is greater. Furthermore, the order I
>> specify these filter in filter list also changes the number of returned
>> rows.
>>
>>
>>
>> Anyone have had similar experience?
>>
>>
>>
>> Thanks
>>
>> --
>> Best Regards,
>> Eko Susilo
>>

Re: Combining PageFilter gives inconsistent number of rows

[Ted Yu <yu...@gmail.com>]

Which version of hbase are you using ?

Is it possible to come up with unit test that shows what you observed ?

There is already coverage in existing unit tests, e.g. TestFilterList which
you can use as template.

Thanks

On Thu, Jun 9, 2016 at 3:41 AM, Eko Susilo <ek...@gmail.com>
wrote:

> Hi All,
>
>
>
> I have problems when combining PageFilter with other filters. I am
> combining SingleColumnValueFilter, KeyOnlyFilter, and PageFilter.
>
> Scan returns different total number of row when pageFilter is present; the
> number of row without page filter is greater. Furthermore, the order I
> specify these filter in filter list also changes the number of returned
> rows.
>
>
>
> Anyone have had similar experience?
>
>
>
> Thanks
>
> --
> Best Regards,
> Eko Susilo
>