Created By: demo
Created At: Wed, 12 Jun 2013 22:14:52 -0500
Input Dataset: 2012 July/SF
Last Submitted At: Wed, 12 Jun 2013 22:14:52 -0500
Last Finished At: Wed, 12 Jun 2013 22:15:43 -0500 (51s)
Source Code
# How many projects created each year?
counts: output sum[int] of int;
p: Project = input;
counts[yearof(p.created_date)] << 1;
Output
Job Output Size: 309 bytes
counts[1969] = 1
counts[1999] = 413
counts[2000] = 5337
counts[2001] = 9875
counts[2002] = 13679
counts[2003] = 15580
counts[2004] = 19519
counts[2005] = 22649
counts[2006] = 27971
counts[2007] = 27363
counts[2008] = 28414
counts[2009] = 39251
counts[2010] = 75200
counts[2011] = 227905
counts[2012] = 108514
Compilation
Status: Finished
Started: Wed, 12 Jun 2013 22:14:52 -0500
Finished: Wed, 12 Jun 2013 22:15:00 -0500 (8s)
Execution
Status: Finished
Started: Wed, 12 Jun 2013 22:15:06 -0500
Finished: Wed, 12 Jun 2013 22:15:43 -0500 (37s)