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

Posted to issues@calcite.apache.org by "Bertil Chapuis (Jira)" <ji...@apache.org> on 2022/12/15 23:18:00 UTC

[jira] [Created] (CALCITE-5437) Implement st_explode with a cursor

Bertil Chapuis created CALCITE-5437:
---------------------------------------

             Summary: 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


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



--
This message was sent by Atlassian Jira
(v8.20.10#820010)