You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by nitin jha <jh...@gmail.com> on 2014/05/23 08:50:17 UTC

Group Concat Support in Phoenix

Hi James,

Thanks for your response. Please feel free to ask for any details(if
required) for this use case.


Use case: Support for group concat

*ex(SQL query):-*

*SELECT student_name,**GROUP_CONCAT(DISTINCT test_score**ORDER BY
test_score DESC SEPARATOR ' ')**FROM student**GROUP BY student_name;*


*Is it possible to achieve this in phoenix?  *



***This is supported in Hive. They have something called as collect_set()*


*Regards,*


*Nitin*