[
https://issues.apache.org/jira/browse/CALCITE-5437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bertil Chapuis updated CALCITE-5437:
------------------------------------
Description:
The goal is to implement ST_Explode with a cursor function, so that the
geometry column of a row can be unnested into multiple rows. Ideally, we would
like to execute a query such as the following:
{code:java}
SELECT *FROM table(ST_Explode(cursor(
SELECT ST_GeomFromText('MULTIPOINT((1 1), (2 2))') as points
UNION ALL SELECT ST_GeomFromText('MULTIPOINT((3 3), (4 4))') as points
)));
GEOM, INDEXPOINT (1 1), 0
POINT (2 2), 1
POINT (3 3), 0
POINT (4 4), 1{code}
was:
The goal is to implement ST_Explode with a cursor function, so that the
geometry column of a row can be unnested into multiple rows. Ideally, we would
like to execute a query such as the following:
SELECT *FROM table(ST_Explode(cursor(
SELECT ST_GeomFromText('MULTIPOINT((1 1), (2 2))') as points
UNION ALL SELECT ST_GeomFromText('MULTIPOINT((3 3), (4 4))') as points
)));
GEOM, INDEXPOINT (1 1), 0
POINT (2 2), 1
POINT (3 3), 0
POINT (4 4), 1
> Implement st_explode with a cursor
> ----------------------------------
>
> Key: CALCITE-5437
> URL: https://issues.apache.org/jira/browse/CALCITE-5437
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Bertil Chapuis
> Priority: Minor
>
> The goal is to implement ST_Explode with a cursor function, so that the
> geometry column of a row can be unnested into multiple rows. Ideally, we
> would like to execute a query such as the following:
> {code:java}
> SELECT *FROM table(ST_Explode(cursor(
> SELECT ST_GeomFromText('MULTIPOINT((1 1), (2 2))') as points
> UNION ALL SELECT ST_GeomFromText('MULTIPOINT((3 3), (4 4))') as points
> )));
> GEOM, INDEXPOINT (1 1), 0
> POINT (2 2), 1
> POINT (3 3), 0
> POINT (4 4), 1{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
