[ 
https://issues.apache.org/jira/browse/IGNITE-4750?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16283710#comment-16283710
 ] 

Taras Ledkov commented on IGNITE-4750:
--------------------------------------

[~vozerov], [~al.psc], [~skalashnikov] I need in primary review for the patch. 
Please take a look.

I guess tow ways to support GROUP_CONCAT in not collocated mode is
1. Use our own aggregate functions for map and reduce query.  On map step: 
accumulates values in collection and returns collection. On reduce step:  
accumulates map's collection in reduce collection and returns sorted / 
distinct. 
The problem is complex {{ORDER BY}} expression inside {{GROUP_CONCAT}} function.

2. Use H2 {{GROUP_CONCAT}} function on reduce step and not-aggregated select 
for map step.
The problem: query can support other aggregate functions.

> SQL: Support GROUP_CONCAT function
> ----------------------------------
>
>                 Key: IGNITE-4750
>                 URL: https://issues.apache.org/jira/browse/IGNITE-4750
>             Project: Ignite
>          Issue Type: Task
>          Components: sql
>            Reporter: Denis Magda
>            Assignee: Taras Ledkov
>
> GROUP_CONCAT function is not supported at the moment. Makes sense to fill 
> this gap:
> http://apache-ignite-users.70518.x6.nabble.com/GROUP-CONCAT-function-is-unsupported-td10757.html



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to