-- This script covers group all. | |
register $PIGMIX_JAR | |
A = load '$HDFS_ROOT/page_views' using org.apache.pig.test.pigmix.udf.PigPerformanceLoader() | |
as (user, action, timespent, query_term, ip_addr, timestamp, | |
estimated_revenue, page_info, page_links); | |
B = foreach A generate user, (int)timespent as timespent, (double)estimated_revenue as estimated_revenue; | |
C = group B all; | |
D = foreach C generate SUM(B.timespent), AVG(B.estimated_revenue); | |
store D into '$PIGMIX_OUTPUT/L8out'; |