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

["Nitin Kumar (JIRA)" <ji...@apache.org>]

Nitin Kumar created PHOENIX-996:
-----------------------------------

             Summary: 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)