-Pivot table with zeros instead of empty
Eugene Morozov 2013-03-06, 15:20
I have a script that gives me following result:
time_grouped = GROUP joined BY (ip, hour);
counts = FOREACH time_grouped GENERATE group.ip as ip, group.hour as hour,
COUNT(joined) as count;
(126.96.36.199, 0, 180)
(188.8.131.52, 1, 84)
(184.108.40.206, 2, 25)
(220.127.116.11, 22, 31)
(18.104.22.168, 23, 2)
That is IP address, hour of day, counter.
I'd like to get following:
(22.214.171.124, (m1,m2, m3, ..., m23))
m1-m23 corresponds to the counter. And if there is nothing for particular
hour, then I'd like to have 0 instead empty value.
The trick here is that if I do not have anything for particular hour, then
I won't have count for it.
Is there a way to achieve the goal?
Thanks in advance
Developer Grid Dynamics