title: Pig: Pulling individual fields out after a GROUP
body: <p>In PigLatin, I want to pull the other fields out of a record I want to select because of an aggregate, such as <code>MAX</code>.</p>
  
  <p>I'm having trouble explaining the problem, so here is an example. Let's say I want to grab the name of the oldest person at a household:</p>
  
  <p>Relation <code>A</code> is four columns, <code>(name, address, zipcode, age)</code></p>
  
  <pre><code>B = GROUP A BY (address, zipcode); # group by the address
  
  # generate the address, the person's age, but how do I grab that person's name?
  C = FOREACH B GENERATE FLATTEN(group), MAX(age), ??? Name ???;
  </code></pre>
  
  <p>How do I generate the name of the person with the <code>MAX</code> age?</p>