[CALCITE-5437] Implement st_explode with a cursor

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: core
• Assignee: Unassigned
• Reporter: Bertil Chapuis
• Created: 15/Dec/22 23:17
• Updated: 15/Dec/22 23:19

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:

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

Issue Links

• is blocked by: CALCITE-5309 Accept cursors as inputs of table functions
• relates to: CALCITE-5281 Implement geometry set returning functions (SRF)