Spark SQL user-defined functions (UDFs) create spark jobs in SQL-like syntax so there is no
need to write code. Location Intelligence SDK for Big Data provides Spark SQL user defined functions for
geometry operations of type constructor, grid, measurement, observer, persistence, predicate,
processing in the
location-intelligence-bigdata-li-sdk-spark3_2.12-<version<.jar.
Refer to the table below to quickly navigate to Spark SQL functions described in this document:
| Type | Description | Name |
|---|---|---|
| Constructor Functions | Construct an instance of WritableGeometry from supported geometry representation formats |
ST_GeomFromGeoJSON |
| ST_GeomFromKML | ||
| ST_GeomFromWKB | ||
| ST_GeomFromWKT | ||
| ST_Point | ||
| Grid Functions | Grid processing functions | ST_GeoHashBoundary |
| ST_GeoHash | ||
| ST_HexagonBoundary | ||
| ST_HexHash | ||
| ST_SquareHashBoundary | ||
| ST_SquareHash | ||
| Measurement Functions | Geometry measurement functions | ST_Area |
| ST_ClosestPoints | ||
| ST_Distance | ||
| ST_Length | ||
| ST_Perimeter | ||
| Observer Functions | Geometry observer functions | ST_X |
| ST_Y | ||
| ST_XMax | ||
| ST_XMin | ||
| ST_YMax | ||
| ST_YMin | ||
| Persistence Functions | Serialize an instance of WritableGeometry to supported geometry representation formats |
ST_ToGeoJSON |
| ST_ToKML | ||
| ST_ToWKB | ||
| ST_ToWKT | ||
| Predicate Functions | Geometry predicate functions | ST_Disjoint |
| ST_Intersects | ||
| ST_Overlaps | ||
| ST_Within | ||
| ST_IsNullGeom | ||
| Processing Functions | Geometry processing functions | ST_Buffer |
| ST_ConvexHull | ||
| ST_Intersection | ||
| ST_Transform | ||
| ST_Union |