[
https://issues.apache.org/jira/browse/CALCITE-5281?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17602547#comment-17602547
]
Julian Hyde commented on CALCITE-5281:
--------------------------------------
{{Uncollect}} is a weird relational operator because it spans the line between
relational (tables) and non-relational (arrays inside individual rows). You
should definitely not write your own relational operator by copy-pasting
{{Uncollect}}. Perhaps you could write a function that returns an array, and
then use {{Uncollect}} to convert that array into a table. But probably better
is to write a table function. See {{TableFunctionTest}} for examples.
> Implement geometry set returning functions (SRF)
> ------------------------------------------------
>
> Key: CALCITE-5281
> URL: https://issues.apache.org/jira/browse/CALCITE-5281
> Project: Calcite
> Issue Type: Improvement
> Components: spatial
> Reporter: Bertil Chapuis
> Assignee: Bertil Chapuis
> Priority: Minor
>
> The idea is to implement set returning functions, such as ST_Explode in H2GIS
> and ST_Dump in PostGIS. Is the Uncollect class a good starting point?
--
This message was sent by Atlassian Jira
(v8.20.10#820010)