Skip to content

Aggregate function

ST_Envelope_Aggr

Introduction: Return the entire envelope boundary of all geometries in A

Format: ST_Envelope_Aggr (A:geometryColumn)

Since: v1.0.0

Spark SQL example:

SELECT ST_Envelope_Aggr(pointdf.arealandmark)
FROM pointdf

ST_Union_Aggr

Introduction: Return the polygon union of all polygons in A

Format: ST_Union_Aggr (A:geometryColumn)

Since: v1.0.0

Spark SQL example:

SELECT ST_Union_Aggr(polygondf.polygonshape)
FROM polygondf

ST_Intersection_Aggr

Introduction: Return the polygon intersection of all polygons in A

Format: ST_Intersection_Aggr (A:geometryColumn)

Since: v1.2.1

Spark SQL example:

SELECT ST_Intersection_Aggr(polygondf.polygonshape)
FROM polygondf


Last update: September 15, 2020 23:40:05