https://community.cloudera.com/t5/Support-Questions/How-to-merge-two-rows-having-same-values-into-single-row-in/m-p/188715#M150808 <P>Hi. collect_list should be able to achieve what you want:</P><PRE>select id ,name ,dob ,concat_ws(',',collect_list(location)) as location from test_analysis group by id ,name ,dob </PRE><P>I found the solution here: <A href="https://stackoverflow.com/questions/44770037/hive-pivot-and-sum">https://stackoverflow.com/questions/44770037/hive-pivot-and-sum</A></P><P>Output should look like this:</P><PRE>1 Bob 08/10/1985 New Jersey,New York,North Carolina 2 John 26/11/1990 Oklahoma </PRE><P>Hope this helps.</P> Fri, 03 Nov 2017 18:19:57 GMT ian_stokes1 2017-11-03T18:19:57Z