pig good

grunt> res = load '/user/hive/warehouse/0hk8ubfx/' 
>> as (guid:chararray, rate:double);
grunt> ret = filter res by rate>0.0;
grunt> ret = limit res 500;

grunt> dump ret;

grunt> cnt = foreach(group ret all) generate COUNT(ret);
grunt> dump cnt;