hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mahender Sarangam <Mahender.BigD...@outlook.com>
Subject Is there any GROUP_CONCAT Function in Hive
Date Wed, 15 Jun 2016 22:46:59 GMT
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.
Mime
View raw message