title: How can I sort concat_ws(';',collect_set(name)) result in hive?
body: <p>How can I sort result of this query alphabetically? </p>
  
  <pre><code>select b6.S_Architect as S_Architect 
    from applications a
         left outer join
         (select id,concat_ws(';' , collect_set(name)) as S_Architect 
            from solution_architect
           group by parentcontentid
         ) b6 on a.id = b6.Id;
  </code></pre>
  
  <p>Expected result</p>
  
  <pre><code>Andy;Bravo;Cindy;David
  </code></pre>
  
  <p>Actual result</p>
  
  <pre><code>Cindy;Bravo;David;Andy
  </code></pre>