st_isempty
function
Applies to: Databricks Runtime 17.1 and above
Preview
This feature is in Public Preview.
Returns true if the input GEOGRAPHY
or GEOMETRY
value does not contain any non-empty points.
Syntax
st_isempty ( geoExpr )
Arguments
geoExpr
: AGEOGRAPHY
orGEOMETRY
value.
Returns
A value of type BOOLEAN
, true if the input GEOGRAPHY
or GEOMETRY
value does not contain any non-empty points.
The function returns NULL
if the input is NULL
.
Examples
SQL
-- Returns false for geometry containing non-empty points.
> SELECT st_isempty(st_geomfromtext('MULTIPOINT(10 34,44 57,EMPTY)'));
false
-- Returns true for geometry containing only empty points.
> SELECT st_isempty(st_geogfromtext('MULTIPOINT(EMPTY,EMPTY)'));
true