title: Max/Min for whole sets of records in PIG
body: <p>I have a set set of records that I am loading from a file and the first thing I need to do is get the max and min of a column. 
  In SQL I would do this with a subquery like this:</p>
  
  <pre><code>   select c.state, c.population, 
  (select max(c.population) from state_info c) as max_pop, 
  (select min(c.population) from state_info c) as min_pop
  from state_info c
  </code></pre>
  
  <p>I assume there must be an easy way to do this in PIG as well but I'm having trouble finding it. It has a MAX and MIN function but when I tried doing the following it didn't work:</p>
  
  <pre><code>records=LOAD '/Users/Winter/School/st_incm.txt'  AS (state:chararray, population:int);
  with_max = FOREACH records GENERATE state, population, MAX(population);
  </code></pre>
  
  <p>This didn't work. I had better luck adding an extra column with the same value to each row and then grouping them on that column. Then getting the max on that new group. This seems like a convoluted way of getting what I want so I thought I'd ask if anyone knows a simpler way.</p>
  
  <p>Thanks in advance for the help.</p>