[jira] [Resolved] (PHOENIX-996) Support for Group concat function in phoenix

["James Taylor (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-996?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor resolved PHOENIX-996.
----------------------------------

    Resolution: Won't Fix

> Support for Group concat function in phoenix
> --------------------------------------------
>
>                 Key: PHOENIX-996
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-996
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: Nitin Kumar
>            Priority: Blocker
>
> Hi James,
> Its really great to see the promptness by phoenix team for resolving certain critical issues/enhancement(particularly all my issues resolved till date).  
> ex:- https://issues.apache.org/jira/browse/PHOENIX-136
> I am again stuck with one use case(and we are in advanced stage of our product which uses phoenix for aggregation etc)
> 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?  
> Note:- This is supported in Hive. They have something called as collect_set()
> Regards,
> Nitin



--
This message was sent by Atlassian JIRA
(v6.2#6252)