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

[liu ming (JIRA)]

[ 
https://issues.apache.org/jira/browse/TRAFODION-2494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)

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

[Anoop Sharma (JIRA)]

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

Anoop Sharma commented on TRAFODION-2494:
-

It will be good to add some details about functions that the Jira is being 
filed for and some examples showing what the usage is. That way one doesnt have 
to search and look for oracle doc on what it does. It will also help to list 
what functionality or subset of it is being proposed to be supported 

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