title: Hive SQL, how to have multiple columns in group_concat?
body: <p>I have data that looks like this:</p>
  
  <pre><code>Customer       DUNS         Employees
     A            1              60
     A            2             100
     A            3              15
     A            4              40
  </code></pre>
  
  <p>What I am wanting is this:</p>
  
  <pre><code>Customer        NEW CONCAT FIELD
     A            1:60, 2:100, 3:15, 4:40
  </code></pre>
  
  <p>Here is what I have so far:</p>
  
  <pre><code>Select 
   Customer
  ,group_concat(cast(DUNS as string)) as DUNS
  ,group_concat(cast(Employees as string)) as 'Emps'
  From MyTable
  group by Customer
  </code></pre>
  
  <p>And here are the results:</p>
  
  <pre><code>Customer        DUNS           EMPS
     A            1, 2, 3, 4     60,100,15,40
  </code></pre>
  
  <p>I am just really struggling to combine these into one field.  I find MySQL syntax that looks like what I need, but it doesn't work in my cloudera/Impala editor.</p>
  
  <p>For the life of me I cannot find where this has been done before, but I'm sure it as somewhere.  How do I edit this query to get that 'NEW CONCAT FIELD'?</p>