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

Posted to issues@trafodion.apache.org by "liu ming (JIRA)" <ji...@apache.org> on 2018/03/20 10:14:00 UTC

[jira] [Commented] (TRAFODION-2494) support listagg function

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

liu ming commented on TRAFODION-2494:
-------------------------------------

Yes, Anoop.

I checked this again, it is an Oracle function, very similar with group_concat, so I will leave this open, and no need to support it until real requirement.

It is part of Oracle compatibility, but no strong requirement for now. It was once required, so I create a Jira to record it.

 

Basic function:
   DEPTNO ENAME
--------- ----------
       10 CLARK
       10 KING
       10 MILLER
       20 ADAMS
       20 FORD
       20 JONES

   DEPTNO AGGREGATED_ENAMES
--------- -------------------------
       10 CLARK,KING,MILLER
       20 ADAMS,FORD,JONES

> support listagg function
> ------------------------
>
>                 Key: TRAFODION-2494
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2494
>             Project: Apache Trafodion
>          Issue Type: Bug
>            Reporter: liu ming
>            Assignee: liu ming
>            Priority: Major
>
> to simulate Oracle's listagg function.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)