AggGeomUnion Function | Geospatial Data Types | Teradata Vantage - 17.10 - AggGeomUnion [Deprecated] - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1181-171K
Language
English (United States)
This deprecated method was replaced by the AggGeom table operator, which provides better performance and no size restriction.

Aggregate function that returns the union of all spatial objects in the aggregation group.

Result Type

Returns an ST_Geometry value.

NULL arguments are not included in the aggregation. If all values in the aggregation are null, the return value is NULL.

Because the order in which the rows are processed and per-AMP results are returned for aggregation can vary from run to run, the ordering of the values in the results can vary between different instances of identical queries. Although the order of the individual values in the returned results can vary, the overall results from the query will be the same when an identical query is run on the same data.