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

liu ming commented on TRAFODION-2163:
-------------------------------------

Hi, Anoop,

Thanks for the valuable comments. 
I was trying to simulate GROUP_CONCAT, and then find out pivot_group already 
implemented. And basic functional test shows it works as expected. So I would 
like to first add MySQL style syntax sugar. And do more tests.

We still just need it for limited use for now IMHO, to meet some basic 
requirements in some real use cases where people have to write code.

And could you say more about 'issues related to parallel execution' ? Is there 
any specific error/issues description about that? So I can take a look and try 
to work on it.

thanks,
Ming

> support MYSQL style function GROUP_CONCAT
> -----------------------------------------
>
>                 Key: TRAFODION-2163
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2163
>             Project: Apache Trafodion
>          Issue Type: Sub-task
>            Reporter: liu ming
>            Assignee: liu ming
>
> One popular MySQL function is GROUP_CONCAT :
> SELECT student_name,
>           GROUP_CONCAT(DISTINCT test_score
>                     ORDER BY test_score asc SEPARATOR ' ')
>           FROM student
>           GROUP BY student_name;   
> Support this syntax.
> This helps migration.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to