title: hive equivalent of group concatenation
body: <p>what is the wrong with this hive query ..trying to do group concatenation</p>
  
  <pre><code>select ID,source_sys, group_concat(Quote||'_'||Quote_size::Integer||'@'||price::Numeric(30,4)
  ||'_'||quote2_size::Integer||'@'||quote2_price::Numeric(30,4),'|') as quotes from xyz_table
  </code></pre>
  
  <p>I am getting the following error</p>
  
  <p>Analysis Exception: Syntax error on line 2:undefined: ...Quote||'_'||Quote_size::Integer||'@'||price ... ^Encountered::Expected: ADD,ALTER .....
  Syntax error</p>