Geospatial function name changes and new functions in Athena engine version 2 - Amazon Athena
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Geospatial function name changes and new functions in Athena engine version 2

This section lists changes in geospatial function names and geospatial functions that are new in Athena engine version 2. For information about other changes as of Athena engine version 2, see Athena engine version 2.

For information about Athena engine versioning, see Athena engine versioning.

Geospatial function name changes in Athena engine version 2

The names of the following functions have changed. In some cases, the input and output types have also changed. For more information, visit the corresponding links.

Prior function name Function name starting in Athena engine version 2
st_coordinate_dimension ST_CoordDim
st_end_point ST_EndPoint
st_exterior_ring ST_ExteriorRing
st_interior_ring_number ST_NumInteriorRing
st_geometry_from_text ST_GeometryFromText
st_is_closed ST_IsClosed
st_is_empty ST_IsEmpty
st_is_ring ST_IsRing
st_max_x ST_XMax
st_max_y ST_YMax
st_min_x ST_XMin
st_min_y ST_YMin
st_point_number ST_NumPoints
st_start_point ST_StartPoint
st_symmetric_difference ST_SymDifference

New geospatial functions in Athena engine version 2

The following geospatial functions are new as of Athena engine version 2. For more information, visit the corresponding links.

Aggregation functions