title: Is there a function in Hive to rollup multiple records into one using a delimiter?
body: <p>I have a table with multiple lines for the same ID as below:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">ID</th>
  <th style="text-align: left;">Company</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">123456</td>
  <td style="text-align: left;">CompanyA</td>
  </tr>
  <tr>
  <td style="text-align: left;">123456</td>
  <td style="text-align: left;">CompanyB</td>
  </tr>
  <tr>
  <td style="text-align: left;">456123</td>
  <td style="text-align: left;">CompanyB</td>
  </tr>
  <tr>
  <td style="text-align: left;">789123</td>
  <td style="text-align: left;">CompanyC</td>
  </tr>
  <tr>
  <td style="text-align: left;">789123</td>
  <td style="text-align: left;">CompanyD</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Is there a function in Hive that can rollup multiple records into one using a delimiter like below:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">ID</th>
  <th style="text-align: left;">Company</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">123456</td>
  <td style="text-align: left;">CompanyA, CompanyB</td>
  </tr>
  <tr>
  <td style="text-align: left;">456123</td>
  <td style="text-align: left;">CompanyB</td>
  </tr>
  <tr>
  <td style="text-align: left;">789123</td>
  <td style="text-align: left;">CompanyC, CompanyD</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I tried using collect_list, but I am not getting the desired results. Hive does not have STUFF() like SQL.</p>
  <p>TIA</p>