Hi, We have Hive table with 3 GB of data like 1000000 rows. We are looking for any functionality in hive, which can perform GROUP_CONCAT Function.
We tried implement Group_Concat function with use Collect_List and Collect_Set. But we are getting heap space error. Because, For each group key around 100000 rows are present, now these rows which needs to be concatenate. Any direct way to concat row data into single string column by GROUP BY.
