title: Max value of collect_list(column) in Hive
body: <p>I am using below command in Hive. and getting correct result.</p>
  
  <pre><code>select acct_id,collect_list(expr_dt) from experiences
      &gt; group by acct_id;
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>900      ["2015-03-31"]
  707       ["2015-03-31","2014-12-10"]
  903       ["2015-03-31"]
  -435       ["2015-03-31"]
  718       ["2015-03-31","2014-06-03"]
  </code></pre>
  
  <p>I want to get the max date for each account.</p>
  
  <p>When I am trying execute below query I am getting error.</p>
  
  <pre><code>select acct_id,max(collect_list(expr_dt)) from experiences
      &gt; group by acct_id;
  </code></pre>
  
  <p>and the error is - </p>
  
  <blockquote>
    <p>SemanticException [Error 10128]: Line 1:19 Not yet supported place for
    UDAF 'collect_list'</p>
  </blockquote>
  
  <p>I want to do total operation in a single query.</p>