title: SQL on Spark: How do I get all values of DISTINCT?
body: <p>So, assume I have the following table:</p>
  
  <pre><code>Name | Color
  ------------------------------
  John | Blue
  Greg | Red
  John | Yellow
  Greg | Red
  Greg | Blue
  </code></pre>
  
  <p>I would like to get a table of the distinct colors for each name - how many and their values. Meaning, something like this:</p>
  
  <pre><code>Name | Distinct | Values
  --------------------------------------
  John |   2      | Blue, Yellow
  Greg |   2      | Red, Blue
  </code></pre>
  
  <p>Any ideas how to do so?</p>