Slide 47
Slide 47 text
Pig DATA
ANALYTICS
B
A
T
C
H
• Obtain the S02 average of each station
calidad_aire = load '/CalidadAire_Gijon' using PigStorage(';') AS
(estacion:chararray, titulo:chararray, latitud:chararray,
longitud:chararray, fecha:chararray, so2:chararray, no:chararray,
co:chararray, pm10:chararray, o3:chararray, dd:chararray,
vv:chararray, tmp:chararray, hr:chararray, prb:chararray,
rs:chararray, ll:chararray, ben:chararray, tol:chararray,
mxil:chararray, pm25:chararray);
grouped = GROUP air_quality BY estacion;
avg = FOREACH grouped GENERATE group, AVG(so2);
dump avg;