Try COUNT_STAR.

-Shahab


On Wed, May 29, 2013 at 9:55 AM, Marco Brinkmann <marco.brinkm...@cope.io>wrote:

> Hi everybody,
>
> I have a rather simple question and scenario, but still I could not find an
> answer in the documention or in other resource:
>
> id, valid
> (1, false)
> (2, false)
>
> records = LOAD 'test.csv' USING PigStorage(',') AS (id:long,
> valid:boolean);
>
> test = FILTER records BY valid == true;
> test_count = FOREACH (GROUP test ALL) GENERATE COUNT(test);
>
> DUMP test_count;
>
>
> I would expect that 'valid_count' nows contains '0'. But the dump is
> completely empty (with 'valid == false' I get '(2)' as expected). I use pig
> 0.11.1.
>
> Could someone point me in the right direction?
>
> Cheers, Marco
>

Reply via email to