Major Description
Our user reported an issue where their scalar results goes missing when having two store statements.
A = load 'test1.txt' using PigStorage('\t') as (a:chararray, count:long);
B = group A all;
C = foreach B generate SUM(A.count) as total ;
store C into 'deleteme6_C' using PigStorage(',');
Z = load 'test2.txt' using PigStorage('\t') as (a:chararray, id:chararray );
Y = group Z by id;
X = foreach Y generate group, C.total;
store X into 'deleteme6_X' using PigStorage(',');
====Inputs
pig> cat test1.txt
a 1
b 2
c 8
d 9
pig> cat test2.txt
a z
b y
c x
pig>
Result X should contain the total count of '20' but instead it's empty.
pig> cat deleteme6_C/part-r-00000 20 pig> cat deleteme6_X/part-r-00000 x, y, z, pig>
This works if we take out first "store C" statement.