st_y function
Applies to: Databricks SQL
Databricks Runtime 17.1 and above
Lakehouse//RT
nota
This feature is not available on Databricks SQL Classic warehouses. To learn more about Databricks SQL warehouses, see SQL warehouse types.
Returns the Y coordinate of the input point GEOMETRY value, or NULL if the point is empty.
Syntax
st_y ( geoExpr )
Arguments
geoExpr: AGEOMETRYvalue.
Returns
A value of type DOUBLE, equal to the Y coordinate of the input point GEOMETRY value.
The function returns NULL if the input is NULL or if the point is empty.
Error conditions
- If the value of
geoExpris not a point, the function returns ST_INVALID_ARGUMENT.INVALID_TYPE.
Examples
SQL
-- Returns the Y coordinate of a non-empty point geometry.
> SELECT st_y(st_geomfromtext('POINT Z (2 3 4)'));
3.0
-- Returns `NULL` for an empty point geometry.
> SELECT st_y(st_geomfromtext('POINT ZM EMPTY'));
NULL