register $chukwaCore
register $chukwaPig
define chukwaLoader org.apache.hadoop.chukwa.ChukwaStorage();
define timePartition_Hadoop_mapred_jobtracker_$timePeriod org.apache.hadoop.chukwa.TimePartition('$timePeriod');
define seqWriter_Hadoop_mapred_jobtracker_$timePeriod org.apache.hadoop.chukwa.ChukwaStorage('c_timestamp','c_recordtype', 'c_application', 'c_cluster','c_source' , 'reduces_completed', 'maps_launched', 'jobs_completed', 'reduces_launched', 'maps_completed', 'jobs_submitted');
A_Hadoop_mapred_jobtracker_$timePeriod = load '$input' using  chukwaLoader as (ts: long,fields);
B_Hadoop_mapred_jobtracker_$timePeriod = FOREACH A_Hadoop_mapred_jobtracker_$timePeriod GENERATE timePartition_Hadoop_mapred_jobtracker_$timePeriod(ts) as time ,fields#'csource' as g0 , fields#'reduces_completed' as f0, fields#'maps_launched' as f1, fields#'jobs_completed' as f2, fields#'reduces_launched' as f3, fields#'maps_completed' as f4, fields#'jobs_submitted' as f5;
C_Hadoop_mapred_jobtracker_$timePeriod = group B_Hadoop_mapred_jobtracker_$timePeriod by (time,g0 );
D_Hadoop_mapred_jobtracker_$timePeriod = FOREACH C_Hadoop_mapred_jobtracker_$timePeriod generate group.time as ts, '$recType', 'downsampling $timePeriod', '$cluster', group.g0 , AVG(B_Hadoop_mapred_jobtracker_$timePeriod.f0) as f0, AVG(B_Hadoop_mapred_jobtracker_$timePeriod.f1) as f1, AVG(B_Hadoop_mapred_jobtracker_$timePeriod.f2) as f2, AVG(B_Hadoop_mapred_jobtracker_$timePeriod.f3) as f3, AVG(B_Hadoop_mapred_jobtracker_$timePeriod.f4) as f4, AVG(B_Hadoop_mapred_jobtracker_$timePeriod.f5) as f5;
-- describe D_Hadoop_mapred_jobtracker_$timePeriod;
-- dump D_Hadoop_mapred_jobtracker_$timePeriod;
store D_Hadoop_mapred_jobtracker_$timePeriod into '$output' using seqWriter_Hadoop_mapred_jobtracker_$timePeriod;