javg() or average()
count()
first()
last()
max()
median()
min()
sum()
unique()
stddev()
stddevp()
var()
varp()
percentile_cont()
percentile_disc()
regr_intercept()
regr_slope()
regr_r2()
grouping()
Windowing Functions
coalesce
Previous Versions
sum()
Returns the sum of a numeric field.
Example - Calculate the Total Meeting Time
Suppose that you have a database of meeting information. Use sum() to see that the total time spent meeting with each account.
1q = load "Meetings";
2q = group q by 'Company';
3q = foreach q generate 'Company' as 'Company', sum('MeetingDuration') as 'sum_meetings';