As far as I understand, there is no equivalent of MySQL group_concat() in Hive. This stackoverflow question is from Sept 2010: http://stackoverflow.com/questions/3703740/combine-multiple-rows-into-one-space-separated-string
Does anyone know any other method to create a delimited list from from table rows? There are a few methods listed in Anthony Molinaro's SQL Cookbook, but all of them use over(partition by) method which is also not available in Hive.