Hi Mat, When you import data into Druid it segments and rolls up the data and stores it in a way that is optimised for OLAP queries. I'm comfortable calling that store a cube. My experience of Druid is limited but my understanding the cube is built as you load the data into it. Personally I use OLAP and cube terminology interchangeably. What do you feel separates the term cube from OLAP? Regards, Ian. ... View more

Hi. collect_list should be able to achieve what you want: select id ,name ,dob ,concat_ws(',',collect_list(location)) as location from test_analysis group by id ,name ,dob I found the solution here: https://stackoverflow.com/questions/44770037/hive-pivot-and-sum Output should look like this: 1 Bob 08/10/1985 New Jersey,New York,North Carolina 2 John 26/11/1990 Oklahoma Hope this helps. ... View more