Impala geospatial functions

The supported geospatial functions in Impala include natively accelerated implementations and the core ESRI-based library.

The following table describes the core functions supported in Cloudera Data Warehouse 2025.0.21.0:

Table 1. Core geospatial functions
Function	Description	Syntax	Return type
`st_EnvIntersects`	Tests if the envelopes (bounding boxes) of two geometries intersect.	`st_EnvIntersects(binary geometry1, binary geometry2)`	BOOLEAN
`st_GeometryType`	Returns the name of the geometry type, such as `ST_POINT` or `ST_LINESTRING`.	`st_GeometryType(binary geometry)`	STRING
`st_MaxX`	Returns the maximum X coordinate of a geometry.	`st_MaxX(binary geometry)`	DOUBLE
`st_MaxY`	Returns the maximum Y coordinate of a geometry.	`st_MaxY(binary geometry)`	DOUBLE
`st_MinX`	Returns the minimum X coordinate of a geometry.	`st_MinX(binary geometry)`	DOUBLE
`st_MinY`	Returns the minimum Y coordinate of a geometry.	`st_MinY(binary geometry)`	DOUBLE
`st_Point`	Constructs a point geometry from X and Y coordinates.	`st_Point(double x, double y)`	BINARY
`st_SetSrid`	Sets the Spatial Reference System Identifier (SRID) for a geometry and returns the modified geometry.	`st_SetSrid(binary geometry, int srid)`	BINARY
`st_Srid`	Returns the Spatial Reference System Identifier (SRID) of a geometry.	`st_Srid(binary geometry)`	INT
`st_X`	Returns the X coordinate of a point geometry.	`st_X(binary point)`	DOUBLE
`st_Y`	Returns the Y coordinate of a point geometry.	`st_Y(binary point)`	DOUBLE