[
https://issues.apache.org/jira/browse/CALCITE-2754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16729444#comment-16729444
]
Julian Hyde commented on CALCITE-2754:
--------------------------------------
As I noted in the other case, LISTAGG is oracle-specific. It is not in the SQL
standard. I would not be surprised if other DBs support it.
I notice that google BigQuery supports STRING_AGG, which is similar.
> LISTAGG support
> ---------------
>
> Key: CALCITE-2754
> URL: https://issues.apache.org/jira/browse/CALCITE-2754
> Project: Calcite
> Issue Type: New Feature
> Components: core
> Affects Versions: 1.18.0
> Reporter: Sergey Nuyanzin
> Assignee: Sergey Nuyanzin
> Priority: Major
> Labels: pull-request-available
>
> Inspired by CALCITE-2224.
> There is an implementation of LISTAGG mentioned in description of CALCITE-2224
> Unfortunately there is no info about LISTAGG in public available SQL:2016
> draft at [1] while there is some description about LISTAGG as feature T625
> e.g.at [2]
> [1] http://jtc1sc32.org/doc/N2551-2600/32N2572T-text_for_ballot-DIS_9075-2.pdf
> [2] https://modern-sql.com/feature/listagg
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
