You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sedona.apache.org by ji...@apache.org on 2024/01/17 17:38:00 UTC
(sedona) branch fix-docs-post-release created (now 9e190964f)
This is an automated email from the ASF dual-hosted git repository.
jiayu pushed a change to branch fix-docs-post-release
in repository https://gitbox.apache.org/repos/asf/sedona.git
at 9e190964f Update snowflake sql
This branch includes the following new commits:
new 810ae437d Update process
new f09d6cb1f Change the next version to 1.6.0-SNAPSHOT
new 9397c8552 Update NOTICE file
new 9e190964f Update snowflake sql
The 4 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
(sedona) 03/04: Update NOTICE file
Posted by ji...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
jiayu pushed a commit to branch fix-docs-post-release
in repository https://gitbox.apache.org/repos/asf/sedona.git
commit 9397c8552a89e8ad16a7edeff68030cc307513d8
Author: Jia Yu <ji...@apache.org>
AuthorDate: Sat Jan 13 21:11:49 2024 -0800
Update NOTICE file
---
NOTICE | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/NOTICE b/NOTICE
index 997b1e2f4..5c46d0e34 100644
--- a/NOTICE
+++ b/NOTICE
@@ -1,5 +1,5 @@
-Apache Sedona (incubating)
-Copyright 2020-2023 The Apache Software Foundation
+Apache Sedona
+Copyright 2020-2024 The Apache Software Foundation
This product includes software developed at
The Apache Software Foundation (http://www.apache.org/).
(sedona) 04/04: Update snowflake sql
Posted by ji...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
jiayu pushed a commit to branch fix-docs-post-release
in repository https://gitbox.apache.org/repos/asf/sedona.git
commit 9e190964fbe7a18c5c10bd70531fff85ae52cffd
Author: Jia Yu <ji...@apache.org>
AuthorDate: Sat Jan 13 21:15:49 2024 -0800
Update snowflake sql
---
docs/image/snowflake/sedona-snowflake.sql | 712 +++++++++++++++---------------
1 file changed, 356 insertions(+), 356 deletions(-)
diff --git a/docs/image/snowflake/sedona-snowflake.sql b/docs/image/snowflake/sedona-snowflake.sql
index ea71e528b..f3ec87975 100644
--- a/docs/image/snowflake/sedona-snowflake.sql
+++ b/docs/image/snowflake/sedona-snowflake.sql
@@ -1,19 +1,11 @@
-- IsNativeApp is false. Generating DDL for User-Managed Snowflake Account
-- UDFs --
-create or replace function sedona.ST_SimplifyPreserveTopology (geometry BINARY, distanceTolerance DOUBLE)
-returns BINARY
-language java
-RETURNS NULL ON NULL INPUT
-IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SimplifyPreserveTopology'
-;
create or replace function sedona.ST_Affine (geometry BINARY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE, g DOUBLE, h DOUBLE, i DOUBLE, xOff DOUBLE, yOff DOUBLE, zOff DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Affine'
;
create or replace function sedona.ST_Affine (geometry BINARY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE)
@@ -21,23 +13,23 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Affine'
;
-create or replace function sedona.ST_Angle (geom1 BINARY, geom2 BINARY, geom3 BINARY)
+create or replace function sedona.ST_Angle (geom1 BINARY, geom2 BINARY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Angle'
;
-create or replace function sedona.ST_Angle (geom1 BINARY, geom2 BINARY)
+create or replace function sedona.ST_Angle (geom1 BINARY, geom2 BINARY, geom3 BINARY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Angle'
;
create or replace function sedona.ST_Angle (geom1 BINARY, geom2 BINARY, geom3 BINARY, geom4 BINARY)
@@ -45,7 +37,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Angle'
;
create or replace function sedona.ST_Area (geometry BINARY)
@@ -53,7 +45,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Area'
;
create or replace function sedona.ST_AsEWKB (geometry BINARY)
@@ -61,7 +53,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsEWKB'
;
create or replace function sedona.ST_AsEWKT (geometry BINARY)
@@ -69,7 +61,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsEWKT'
;
create or replace function sedona.ST_AsGML (geometry BINARY)
@@ -77,7 +69,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsGML'
;
create or replace function sedona.ST_AsKML (geometry BINARY)
@@ -85,7 +77,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsKML'
;
create or replace function sedona.ST_Azimuth (left BINARY, right BINARY)
@@ -93,7 +85,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Azimuth'
;
create or replace function sedona.ST_Buffer (geometry BINARY, radius DOUBLE)
@@ -101,7 +93,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Buffer'
;
create or replace function sedona.ST_Covers (leftGeometry BINARY, rightGeometry BINARY)
@@ -109,7 +101,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Covers'
;
create or replace function sedona.ST_Crosses (leftGeometry BINARY, rightGeometry BINARY)
@@ -117,7 +109,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Crosses'
;
create or replace function sedona.ST_Degrees (angleInRadian DOUBLE)
@@ -125,7 +117,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Degrees'
;
create or replace function sedona.ST_Equals (leftGeometry BINARY, rightGeometry BINARY)
@@ -133,7 +125,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Equals'
;
create or replace function sedona.ST_Force2D (geometry BINARY)
@@ -141,7 +133,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Force2D'
;
create or replace function sedona.ST_GeoHash (geometry BINARY, precision NUMBER)
@@ -149,7 +141,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeoHash'
;
create or replace function sedona.ST_IsEmpty (geometry BINARY)
@@ -157,7 +149,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsEmpty'
;
create or replace function sedona.ST_IsRing (geometry BINARY)
@@ -165,23 +157,23 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsRing'
;
-create or replace function sedona.ST_IsValid (geometry BINARY)
+create or replace function sedona.ST_IsValid (geometry BINARY, flags NUMBER)
returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsValid'
;
-create or replace function sedona.ST_IsValid (geometry BINARY, flags NUMBER)
+create or replace function sedona.ST_IsValid (geometry BINARY)
returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsValid'
;
create or replace function sedona.ST_Length (geometry BINARY)
@@ -189,7 +181,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Length'
;
create or replace function sedona.ST_Multi (geometry BINARY)
@@ -197,7 +189,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Multi'
;
create or replace function sedona.ST_NDims (geometry BINARY)
@@ -205,7 +197,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NDims'
;
create or replace function sedona.ST_NPoints (geometry BINARY)
@@ -213,7 +205,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NPoints'
;
create or replace function sedona.ST_Point (x DOUBLE, y DOUBLE)
@@ -221,7 +213,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Point'
;
create or replace function sedona.ST_PointN (geometry BINARY, n NUMBER)
@@ -229,7 +221,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointN'
;
create or replace function sedona.ST_PointZ (x DOUBLE, y DOUBLE, z DOUBLE, srid NUMBER)
@@ -237,7 +229,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointZ'
;
create or replace function sedona.ST_PointZ (x DOUBLE, y DOUBLE, z DOUBLE)
@@ -245,7 +237,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointZ'
;
create or replace function sedona.ST_Polygon (geometry BINARY, srid NUMBER)
@@ -253,7 +245,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Polygon'
;
create or replace function sedona.ST_Reverse (geometry BINARY)
@@ -261,7 +253,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Reverse'
;
create or replace function sedona.ST_SRID (geometry BINARY)
@@ -269,7 +261,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SRID'
;
create or replace function sedona.ST_AsText (geometry BINARY)
@@ -277,7 +269,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsText'
;
create or replace function sedona.ST_SetSRID (geometry BINARY, srid NUMBER)
@@ -285,7 +277,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SetSRID'
;
create or replace function sedona.ST_Split (input BINARY, blade BINARY)
@@ -293,7 +285,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Split'
;
create or replace function sedona.ST_Touches (leftGeometry BINARY, rightGeometry BINARY)
@@ -301,7 +293,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Touches'
;
create or replace function sedona.ST_Union (leftGeom BINARY, rightGeom BINARY)
@@ -309,7 +301,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Union'
;
create or replace function sedona.ST_Within (leftGeometry BINARY, rightGeometry BINARY)
@@ -317,7 +309,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Within'
;
create or replace function sedona.ST_X (geometry BINARY)
@@ -325,7 +317,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_X'
;
create or replace function sedona.ST_XMax (geometry BINARY)
@@ -333,7 +325,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_XMax'
;
create or replace function sedona.ST_XMin (geometry BINARY)
@@ -341,7 +333,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_XMin'
;
create or replace function sedona.ST_Y (geometry BINARY)
@@ -349,7 +341,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Y'
;
create or replace function sedona.ST_YMax (geometry BINARY)
@@ -357,7 +349,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_YMax'
;
create or replace function sedona.ST_YMin (geometry BINARY)
@@ -365,7 +357,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_YMin'
;
create or replace function sedona.ST_Z (geometry BINARY)
@@ -373,7 +365,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Z'
;
create or replace function sedona.ST_ZMax (geometry BINARY)
@@ -381,7 +373,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ZMax'
;
create or replace function sedona.ST_ZMin (geometry BINARY)
@@ -389,7 +381,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ZMin'
;
create or replace function sedona.ST_DWithin (geomA BINARY, geomB BINARY, distance DOUBLE)
@@ -397,7 +389,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DWithin'
;
create or replace function sedona.ST_Force3D (geom BINARY, zValue DOUBLE)
@@ -405,7 +397,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Force3D'
;
create or replace function sedona.ST_Force3D (geom BINARY)
@@ -413,7 +405,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Force3D'
;
create or replace function sedona.ST_NRings (geom BINARY)
@@ -421,7 +413,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NRings'
;
create or replace function sedona.GeometryType (geometry BINARY)
@@ -429,7 +421,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.GeometryType'
;
create or replace function sedona.ST_AddPoint (linestring BINARY, point BINARY, position NUMBER)
@@ -437,7 +429,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AddPoint'
;
create or replace function sedona.ST_AsBinary (geometry BINARY)
@@ -445,7 +437,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsBinary'
;
create or replace function sedona.ST_AsGeoJSON (geometry BINARY)
@@ -453,7 +445,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsGeoJSON'
;
create or replace function sedona.ST_Boundary (geometry BINARY)
@@ -461,7 +453,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Boundary'
;
create or replace function sedona.ST_BoundingDiagonal (geometry BINARY)
@@ -469,7 +461,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_BoundingDiagonal'
;
create or replace function sedona.ST_BuildArea (geometry BINARY)
@@ -477,7 +469,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_BuildArea'
;
create or replace function sedona.ST_Centroid (geometry BINARY)
@@ -485,7 +477,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Centroid'
;
create or replace function sedona.ST_ClosestPoint (geometry1 BINARY, geometry2 BINARY)
@@ -493,39 +485,39 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ClosestPoint'
;
-create or replace function sedona.ST_CollectionExtract (geometry BINARY)
+create or replace function sedona.ST_CollectionExtract (geometry BINARY, geomType NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_CollectionExtract'
;
-create or replace function sedona.ST_CollectionExtract (geometry BINARY, geomType NUMBER)
+create or replace function sedona.ST_CollectionExtract (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_CollectionExtract'
;
-create or replace function sedona.ST_ConcaveHull (geometry BINARY, pctConvex DOUBLE)
+create or replace function sedona.ST_ConcaveHull (geometry BINARY, pctConvex DOUBLE, allowHoles BOOLEAN)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ConcaveHull'
;
-create or replace function sedona.ST_ConcaveHull (geometry BINARY, pctConvex DOUBLE, allowHoles BOOLEAN)
+create or replace function sedona.ST_ConcaveHull (geometry BINARY, pctConvex DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ConcaveHull'
;
create or replace function sedona.ST_Contains (leftGeometry BINARY, rightGeometry BINARY)
@@ -533,7 +525,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Contains'
;
create or replace function sedona.ST_CoordDim (geometry BINARY)
@@ -541,7 +533,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_CoordDim'
;
create or replace function sedona.ST_ConvexHull (geometry BINARY)
@@ -549,7 +541,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ConvexHull'
;
create or replace function sedona.ST_CoveredBy (leftGeometry BINARY, rightGeometry BINARY)
@@ -557,7 +549,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_CoveredBy'
;
create or replace function sedona.ST_Difference (leftGeometry BINARY, rightGeometry BINARY)
@@ -565,7 +557,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Difference'
;
create or replace function sedona.ST_Dimension (geometry BINARY)
@@ -573,7 +565,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Dimension'
;
create or replace function sedona.ST_Disjoint (leftGeometry BINARY, rightGeometry BINARY)
@@ -581,7 +573,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Disjoint'
;
create or replace function sedona.ST_Distance (left BINARY, right BINARY)
@@ -589,7 +581,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Distance'
;
create or replace function sedona.ST_3DDistance (left BINARY, right BINARY)
@@ -597,7 +589,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_3DDistance'
;
create or replace function sedona.ST_DumpPoints (geometry BINARY)
@@ -605,7 +597,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DumpPoints'
;
create or replace function sedona.ST_EndPoint (geometry BINARY)
@@ -613,7 +605,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_EndPoint'
;
create or replace function sedona.ST_Envelope (geometry BINARY)
@@ -621,7 +613,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Envelope'
;
create or replace function sedona.ST_ExteriorRing (geometry BINARY)
@@ -629,7 +621,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ExteriorRing'
;
create or replace function sedona.ST_FlipCoordinates (geometry BINARY)
@@ -637,7 +629,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_FlipCoordinates'
;
create or replace function sedona.ST_Force_2D (geometry BINARY)
@@ -645,7 +637,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Force_2D'
;
create or replace function sedona.ST_GeomFromGML (gml VARCHAR)
@@ -653,7 +645,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromGML'
;
create or replace function sedona.ST_GeomFromGeoHash (geoHash VARCHAR, precision NUMBER)
@@ -661,7 +653,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromGeoHash'
;
create or replace function sedona.ST_GeomFromGeoJSON (geoJson VARCHAR)
@@ -669,7 +661,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromGeoJSON'
;
create or replace function sedona.ST_GeomFromKML (kml VARCHAR)
@@ -677,23 +669,23 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromKML'
;
-create or replace function sedona.ST_GeomFromText (wkt VARCHAR)
+create or replace function sedona.ST_GeomFromText (wkt VARCHAR, srid NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromText'
;
-create or replace function sedona.ST_GeomFromText (wkt VARCHAR, srid NUMBER)
+create or replace function sedona.ST_GeomFromText (wkt VARCHAR)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromText'
;
create or replace function sedona.ST_GeomFromWKB (wkb BINARY)
@@ -701,23 +693,23 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromWKB'
;
-create or replace function sedona.ST_GeomFromWKT (wkt VARCHAR, srid NUMBER)
+create or replace function sedona.ST_GeomFromWKT (wkt VARCHAR)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromWKT'
;
-create or replace function sedona.ST_GeomFromWKT (wkt VARCHAR)
+create or replace function sedona.ST_GeomFromWKT (wkt VARCHAR, srid NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromWKT'
;
create or replace function sedona.ST_GeometryN (geometry BINARY, n NUMBER)
@@ -725,7 +717,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometryN'
;
create or replace function sedona.ST_GeometryType (geometry BINARY)
@@ -733,23 +725,23 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometryType'
;
-create or replace function sedona.ST_HausdorffDistance (geom1 BINARY, geom2 BINARY, densifyFrac DOUBLE)
+create or replace function sedona.ST_HausdorffDistance (geom1 BINARY, geom2 BINARY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_HausdorffDistance'
;
-create or replace function sedona.ST_HausdorffDistance (geom1 BINARY, geom2 BINARY)
+create or replace function sedona.ST_HausdorffDistance (geom1 BINARY, geom2 BINARY, densifyFrac DOUBLE)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_HausdorffDistance'
;
create or replace function sedona.ST_InteriorRingN (geometry BINARY, n NUMBER)
@@ -757,7 +749,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_InteriorRingN'
;
create or replace function sedona.ST_Intersection (leftGeometry BINARY, rightGeometry BINARY)
@@ -765,7 +757,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Intersection'
;
create or replace function sedona.ST_Intersects (leftGeometry BINARY, rightGeometry BINARY)
@@ -773,7 +765,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Intersects'
;
create or replace function sedona.ST_IsClosed (geometry BINARY)
@@ -781,7 +773,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsClosed'
;
create or replace function sedona.ST_IsCollection (geometry BINARY)
@@ -789,7 +781,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsCollection'
;
create or replace function sedona.ST_IsSimple (geometry BINARY)
@@ -797,7 +789,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsSimple'
;
create or replace function sedona.ST_IsValidReason (geometry BINARY)
@@ -805,7 +797,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsValidReason'
;
create or replace function sedona.ST_IsValidReason (geometry BINARY, flags NUMBER)
@@ -813,7 +805,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsValidReason'
;
create or replace function sedona.ST_LineFromMultiPoint (geometry BINARY)
@@ -821,7 +813,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineFromMultiPoint'
;
create or replace function sedona.ST_LineFromText (geomString VARCHAR)
@@ -829,7 +821,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineFromText'
;
create or replace function sedona.ST_LineInterpolatePoint (geom BINARY, fraction DOUBLE)
@@ -837,7 +829,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineInterpolatePoint'
;
create or replace function sedona.ST_LineLocatePoint (geom BINARY, point BINARY)
@@ -845,7 +837,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineLocatePoint'
;
create or replace function sedona.ST_LineMerge (geometry BINARY)
@@ -853,7 +845,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineMerge'
;
create or replace function sedona.ST_LineStringFromText (geomString VARCHAR, delimiter VARCHAR)
@@ -861,7 +853,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineStringFromText'
;
create or replace function sedona.ST_LineSubstring (geom BINARY, fromFraction DOUBLE, toFraction DOUBLE)
@@ -869,7 +861,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineSubstring'
;
create or replace function sedona.ST_MakeLine (geometryCollection BINARY)
@@ -877,7 +869,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakeLine'
;
create or replace function sedona.ST_MakeLine (point1 BINARY, point2 BINARY)
@@ -885,47 +877,47 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakeLine'
;
-create or replace function sedona.ST_MakePoint (x DOUBLE, y DOUBLE)
+create or replace function sedona.ST_MakePoint (x DOUBLE, y DOUBLE, z DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePoint'
;
-create or replace function sedona.ST_MakePoint (x DOUBLE, y DOUBLE, z DOUBLE)
+create or replace function sedona.ST_MakePoint (x DOUBLE, y DOUBLE, z DOUBLE, m DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePoint'
;
-create or replace function sedona.ST_MakePoint (x DOUBLE, y DOUBLE, z DOUBLE, m DOUBLE)
+create or replace function sedona.ST_MakePoint (x DOUBLE, y DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePoint'
;
-create or replace function sedona.ST_MLineFromText (wkt VARCHAR, srid NUMBER)
+create or replace function sedona.ST_MLineFromText (wkt VARCHAR)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MLineFromText'
;
-create or replace function sedona.ST_MLineFromText (wkt VARCHAR)
+create or replace function sedona.ST_MLineFromText (wkt VARCHAR, srid NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MLineFromText'
;
create or replace function sedona.ST_MPolyFromText (wkt VARCHAR)
@@ -933,7 +925,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MPolyFromText'
;
create or replace function sedona.ST_MPolyFromText (wkt VARCHAR, srid NUMBER)
@@ -941,7 +933,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MPolyFromText'
;
create or replace function sedona.ST_MakePolygon (shell BINARY, holes BINARY)
@@ -949,7 +941,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePolygon'
;
create or replace function sedona.ST_MakePolygon (shell BINARY)
@@ -957,7 +949,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePolygon'
;
create or replace function sedona.ST_MakeValid (geometry BINARY, keepCollapsed BOOLEAN)
@@ -965,7 +957,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakeValid'
;
create or replace function sedona.ST_MakeValid (geometry BINARY)
@@ -973,7 +965,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakeValid'
;
create or replace function sedona.ST_MinimumBoundingCircle (geometry BINARY, quadrantSegments NUMBER)
@@ -981,7 +973,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MinimumBoundingCircle'
;
create or replace function sedona.ST_Normalize (geometry BINARY)
@@ -989,7 +981,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Normalize'
;
create or replace function sedona.ST_NumGeometries (geometry BINARY)
@@ -997,7 +989,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NumGeometries'
;
create or replace function sedona.ST_NumInteriorRings (geometry BINARY)
@@ -1005,7 +997,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NumInteriorRings'
;
create or replace function sedona.ST_OrderingEquals (leftGeometry BINARY, rightGeometry BINARY)
@@ -1013,7 +1005,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_OrderingEquals'
;
create or replace function sedona.ST_Overlaps (leftGeometry BINARY, rightGeometry BINARY)
@@ -1021,7 +1013,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Overlaps'
;
create or replace function sedona.ST_PointFromText (geomString VARCHAR, geomFormat VARCHAR)
@@ -1029,7 +1021,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointFromText'
;
create or replace function sedona.ST_PointOnSurface (geometry BINARY)
@@ -1037,7 +1029,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointOnSurface'
;
create or replace function sedona.ST_PolygonFromEnvelope (minX DOUBLE, minY DOUBLE, maxX DOUBLE, maxY DOUBLE)
@@ -1045,7 +1037,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PolygonFromEnvelope'
;
create or replace function sedona.ST_PolygonFromText (geomString VARCHAR, delimiter VARCHAR)
@@ -1053,7 +1045,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PolygonFromText'
;
create or replace function sedona.ST_PrecisionReduce (geometry BINARY, precisionScale NUMBER)
@@ -1061,7 +1053,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PrecisionReduce'
;
create or replace function sedona.ST_ReducePrecision (geometry BINARY, precisionScale NUMBER)
@@ -1069,23 +1061,23 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ReducePrecision'
;
-create or replace function sedona.ST_RemovePoint (linestring BINARY, position NUMBER)
+create or replace function sedona.ST_RemovePoint (linestring BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_RemovePoint'
;
-create or replace function sedona.ST_RemovePoint (linestring BINARY)
+create or replace function sedona.ST_RemovePoint (linestring BINARY, position NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_RemovePoint'
;
create or replace function sedona.ST_S2CellIDs (input BINARY, level NUMBER)
@@ -1093,7 +1085,7 @@ returns ARRAY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_S2CellIDs'
;
create or replace function sedona.ST_SetPoint (linestring BINARY, position NUMBER, point BINARY)
@@ -1101,7 +1093,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SetPoint'
;
create or replace function sedona.ST_StartPoint (geometry BINARY)
@@ -1109,7 +1101,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_StartPoint'
;
create or replace function sedona.ST_SubDivide (geometry BINARY, maxVertices NUMBER)
@@ -1117,7 +1109,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SubDivide'
;
create or replace function sedona.ST_SymDifference (leftGeom BINARY, rightGeom BINARY)
@@ -1125,7 +1117,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SymDifference'
;
create or replace function sedona.ST_Transform (geometry BINARY, sourceCRS VARCHAR, targetCRS VARCHAR, lenient BOOLEAN)
@@ -1133,7 +1125,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Transform'
;
create or replace function sedona.ST_Transform (geometry BINARY, sourceCRS VARCHAR, targetCRS VARCHAR)
@@ -1141,7 +1133,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Transform'
;
create or replace function sedona.ST_VoronoiPolygons (geometry BINARY, tolerance DOUBLE)
@@ -1149,23 +1141,23 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_VoronoiPolygons'
;
-create or replace function sedona.ST_VoronoiPolygons (geometry BINARY, tolerance DOUBLE, extent BINARY)
+create or replace function sedona.ST_VoronoiPolygons (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_VoronoiPolygons'
;
-create or replace function sedona.ST_VoronoiPolygons (geometry BINARY)
+create or replace function sedona.ST_VoronoiPolygons (geometry BINARY, tolerance DOUBLE, extent BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_VoronoiPolygons'
;
create or replace function sedona.ST_AreaSpheroid (geometry BINARY)
@@ -1173,7 +1165,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AreaSpheroid'
;
create or replace function sedona.ST_DistanceSphere (geomA BINARY, geomB BINARY)
@@ -1181,7 +1173,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DistanceSphere'
;
create or replace function sedona.ST_DistanceSphere (geomA BINARY, geomB BINARY, radius DOUBLE)
@@ -1189,7 +1181,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DistanceSphere'
;
create or replace function sedona.ST_DistanceSpheroid (geomA BINARY, geomB BINARY)
@@ -1197,7 +1189,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DistanceSpheroid'
;
create or replace function sedona.ST_FrechetDistance (geomA BINARY, geomB BINARY)
@@ -1205,7 +1197,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_FrechetDistance'
;
create or replace function sedona.ST_LengthSpheroid (geom BINARY)
@@ -1213,39 +1205,39 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LengthSpheroid'
;
-create or replace function sedona.ST_GeometricMedian (geom BINARY, tolerance FLOAT, maxIter NUMBER)
+create or replace function sedona.ST_GeometricMedian (geom BINARY, tolerance FLOAT, maxIter NUMBER, failIfNotConverged BOOLEAN)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometricMedian'
;
-create or replace function sedona.ST_GeometricMedian (geom BINARY, tolerance FLOAT, maxIter NUMBER, failIfNotConverged BOOLEAN)
+create or replace function sedona.ST_GeometricMedian (geom BINARY, tolerance FLOAT)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometricMedian'
;
-create or replace function sedona.ST_GeometricMedian (geom BINARY, tolerance FLOAT)
+create or replace function sedona.ST_GeometricMedian (geom BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometricMedian'
;
-create or replace function sedona.ST_GeometricMedian (geom BINARY)
+create or replace function sedona.ST_GeometricMedian (geom BINARY, tolerance FLOAT, maxIter NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometricMedian'
;
create or replace function sedona.ST_NumPoints (geom BINARY)
@@ -1253,7 +1245,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NumPoints'
;
create or replace function sedona.ST_Translate (geom BINARY, deltaX DOUBLE, deltaY DOUBLE)
@@ -1261,7 +1253,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Translate'
;
create or replace function sedona.ST_Translate (geom BINARY, deltaX DOUBLE, deltaY DOUBLE, deltaZ DOUBLE)
@@ -1269,31 +1261,31 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Translate'
;
-create or replace function sedona.ST_SimplifyPreserveTopology (geometry GEOMETRY, distanceTolerance DOUBLE)
-returns GEOMETRY
+create or replace function sedona.ST_SimplifyPreserveTopology (geometry BINARY, distanceTolerance DOUBLE)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SimplifyPreserveTopology'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SimplifyPreserveTopology'
;
-create or replace function sedona.ST_Affine (geometry GEOMETRY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE, g DOUBLE, h DOUBLE, i DOUBLE, xOff DOUBLE, yOff DOUBLE, zOff DOUBLE)
+create or replace function sedona.ST_Affine (geometry GEOMETRY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE)
returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Affine'
;
-create or replace function sedona.ST_Affine (geometry GEOMETRY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE)
+create or replace function sedona.ST_Affine (geometry GEOMETRY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE, g DOUBLE, h DOUBLE, i DOUBLE, xOff DOUBLE, yOff DOUBLE, zOff DOUBLE)
returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Affine'
;
create or replace function sedona.ST_Angle (geom1 GEOMETRY, geom2 GEOMETRY, geom3 GEOMETRY)
@@ -1301,7 +1293,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Angle'
;
create or replace function sedona.ST_Angle (geom1 GEOMETRY, geom2 GEOMETRY)
@@ -1309,7 +1301,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Angle'
;
create or replace function sedona.ST_Angle (geom1 GEOMETRY, geom2 GEOMETRY, geom3 GEOMETRY, geom4 GEOMETRY)
@@ -1317,7 +1309,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Angle'
;
create or replace function sedona.ST_Area (geometry GEOMETRY)
@@ -1325,7 +1317,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Area'
;
create or replace function sedona.ST_AsEWKB (geometry GEOMETRY)
@@ -1333,7 +1325,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsEWKB'
;
create or replace function sedona.ST_AsEWKT (geometry GEOMETRY)
@@ -1341,7 +1333,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsEWKT'
;
create or replace function sedona.ST_AsGML (geometry GEOMETRY)
@@ -1349,7 +1341,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsGML'
;
create or replace function sedona.ST_AsKML (geometry GEOMETRY)
@@ -1357,7 +1349,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsKML'
;
create or replace function sedona.ST_Azimuth (left GEOMETRY, right GEOMETRY)
@@ -1365,7 +1357,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Azimuth'
;
create or replace function sedona.ST_Buffer (geometry GEOMETRY, radius DOUBLE)
@@ -1373,7 +1365,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Buffer'
;
create or replace function sedona.ST_Covers (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
@@ -1381,7 +1373,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Covers'
;
create or replace function sedona.ST_Crosses (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
@@ -1389,7 +1381,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Crosses'
;
create or replace function sedona.ST_Equals (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
@@ -1397,7 +1389,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Equals'
;
create or replace function sedona.ST_Force2D (geometry GEOMETRY)
@@ -1405,7 +1397,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force2D'
;
create or replace function sedona.ST_GeoHash (geometry GEOMETRY, precision NUMBER)
@@ -1413,7 +1405,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeoHash'
;
create or replace function sedona.ST_IsEmpty (geometry GEOMETRY)
@@ -1421,7 +1413,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsEmpty'
;
create or replace function sedona.ST_IsRing (geometry GEOMETRY)
@@ -1429,23 +1421,23 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsRing'
;
-create or replace function sedona.ST_IsValid (geometry GEOMETRY, flags NUMBER)
+create or replace function sedona.ST_IsValid (geometry GEOMETRY)
returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValid'
;
-create or replace function sedona.ST_IsValid (geometry GEOMETRY)
+create or replace function sedona.ST_IsValid (geometry GEOMETRY, flags NUMBER)
returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValid'
;
create or replace function sedona.ST_Length (geometry GEOMETRY)
@@ -1453,7 +1445,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Length'
;
create or replace function sedona.ST_Multi (geometry GEOMETRY)
@@ -1461,7 +1453,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Multi'
;
create or replace function sedona.ST_NDims (geometry GEOMETRY)
@@ -1469,7 +1461,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NDims'
;
create or replace function sedona.ST_NPoints (geometry GEOMETRY)
@@ -1477,7 +1469,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NPoints'
;
create or replace function sedona.ST_PointN (geometry GEOMETRY, n NUMBER)
@@ -1485,7 +1477,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_PointN'
;
create or replace function sedona.ST_Polygon (geometry GEOMETRY, srid NUMBER)
@@ -1493,7 +1485,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Polygon'
;
create or replace function sedona.ST_Reverse (geometry GEOMETRY)
@@ -1501,7 +1493,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Reverse'
;
create or replace function sedona.ST_SRID (geometry GEOMETRY)
@@ -1509,7 +1501,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SRID'
;
create or replace function sedona.ST_AsText (geometry GEOMETRY)
@@ -1517,7 +1509,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsText'
;
create or replace function sedona.ST_SetSRID (geometry GEOMETRY, srid NUMBER)
@@ -1525,7 +1517,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SetSRID'
;
create or replace function sedona.ST_Split (input GEOMETRY, blade GEOMETRY)
@@ -1533,7 +1525,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Split'
;
create or replace function sedona.ST_Touches (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
@@ -1541,7 +1533,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Touches'
;
create or replace function sedona.ST_Union (leftGeom GEOMETRY, rightGeom GEOMETRY)
@@ -1549,7 +1541,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Union'
;
create or replace function sedona.ST_Within (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
@@ -1557,7 +1549,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Within'
;
create or replace function sedona.ST_X (geometry GEOMETRY)
@@ -1565,7 +1557,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_X'
;
create or replace function sedona.ST_XMax (geometry GEOMETRY)
@@ -1573,7 +1565,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_XMax'
;
create or replace function sedona.ST_XMin (geometry GEOMETRY)
@@ -1581,7 +1573,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_XMin'
;
create or replace function sedona.ST_Y (geometry GEOMETRY)
@@ -1589,7 +1581,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Y'
;
create or replace function sedona.ST_YMax (geometry GEOMETRY)
@@ -1597,7 +1589,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_YMax'
;
create or replace function sedona.ST_YMin (geometry GEOMETRY)
@@ -1605,7 +1597,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_YMin'
;
create or replace function sedona.ST_Z (geometry GEOMETRY)
@@ -1613,7 +1605,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Z'
;
create or replace function sedona.ST_ZMax (geometry GEOMETRY)
@@ -1621,7 +1613,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ZMax'
;
create or replace function sedona.ST_ZMin (geometry GEOMETRY)
@@ -1629,7 +1621,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ZMin'
;
create or replace function sedona.ST_DWithin (geomA GEOMETRY, geomB GEOMETRY, distance DOUBLE)
@@ -1637,7 +1629,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DWithin'
;
create or replace function sedona.ST_Force3D (geom GEOMETRY, zValue DOUBLE)
@@ -1645,7 +1637,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force3D'
;
create or replace function sedona.ST_Force3D (geom GEOMETRY)
@@ -1653,7 +1645,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force3D'
;
create or replace function sedona.ST_NRings (geom GEOMETRY)
@@ -1661,7 +1653,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NRings'
;
create or replace function sedona.GeometryType (geometry GEOMETRY)
@@ -1669,7 +1661,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.GeometryType'
;
create or replace function sedona.ST_AddPoint (linestring GEOMETRY, point GEOMETRY, position NUMBER)
@@ -1677,7 +1669,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AddPoint'
;
create or replace function sedona.ST_AsBinary (geometry GEOMETRY)
@@ -1685,7 +1677,7 @@ returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsBinary'
;
create or replace function sedona.ST_AsGeoJSON (geometry GEOMETRY)
@@ -1693,7 +1685,7 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsGeoJSON'
;
create or replace function sedona.ST_Boundary (geometry GEOMETRY)
@@ -1701,7 +1693,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Boundary'
;
create or replace function sedona.ST_BoundingDiagonal (geometry GEOMETRY)
@@ -1709,7 +1701,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_BoundingDiagonal'
;
create or replace function sedona.ST_BuildArea (geometry GEOMETRY)
@@ -1717,7 +1709,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_BuildArea'
;
create or replace function sedona.ST_Centroid (geometry GEOMETRY)
@@ -1725,7 +1717,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Centroid'
;
create or replace function sedona.ST_ClosestPoint (geometry1 GEOMETRY, geometry2 GEOMETRY)
@@ -1733,7 +1725,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ClosestPoint'
;
create or replace function sedona.ST_CollectionExtract (geometry GEOMETRY, geomType NUMBER)
@@ -1741,7 +1733,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CollectionExtract'
;
create or replace function sedona.ST_CollectionExtract (geometry GEOMETRY)
@@ -1749,7 +1741,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CollectionExtract'
;
create or replace function sedona.ST_ConcaveHull (geometry GEOMETRY, pctConvex DOUBLE)
@@ -1757,7 +1749,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ConcaveHull'
;
create or replace function sedona.ST_ConcaveHull (geometry GEOMETRY, pctConvex DOUBLE, allowHoles BOOLEAN)
@@ -1765,7 +1757,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ConcaveHull'
;
create or replace function sedona.ST_Contains (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
@@ -1773,7 +1765,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Contains'
;
create or replace function sedona.ST_CoordDim (geometry GEOMETRY)
@@ -1781,7 +1773,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CoordDim'
;
create or replace function sedona.ST_ConvexHull (geometry GEOMETRY)
@@ -1789,7 +1781,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ConvexHull'
;
create or replace function sedona.ST_CoveredBy (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
@@ -1797,7 +1789,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CoveredBy'
;
create or replace function sedona.ST_Difference (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
@@ -1805,7 +1797,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Difference'
;
create or replace function sedona.ST_Dimension (geometry GEOMETRY)
@@ -1813,7 +1805,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Dimension'
;
create or replace function sedona.ST_Disjoint (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
@@ -1821,7 +1813,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Disjoint'
;
create or replace function sedona.ST_Distance (left GEOMETRY, right GEOMETRY)
@@ -1829,7 +1821,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Distance'
;
create or replace function sedona.ST_3DDistance (left GEOMETRY, right GEOMETRY)
@@ -1837,7 +1829,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_3DDistance'
;
create or replace function sedona.ST_DumpPoints (geometry GEOMETRY)
@@ -1845,7 +1837,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DumpPoints'
;
create or replace function sedona.ST_EndPoint (geometry GEOMETRY)
@@ -1853,7 +1845,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_EndPoint'
;
create or replace function sedona.ST_Envelope (geometry GEOMETRY)
@@ -1861,7 +1853,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Envelope'
;
create or replace function sedona.ST_ExteriorRing (geometry GEOMETRY)
@@ -1869,7 +1861,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ExteriorRing'
;
create or replace function sedona.ST_FlipCoordinates (geometry GEOMETRY)
@@ -1877,7 +1869,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_FlipCoordinates'
;
create or replace function sedona.ST_Force_2D (geometry GEOMETRY)
@@ -1885,7 +1877,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force_2D'
;
create or replace function sedona.ST_GeometryN (geometry GEOMETRY, n NUMBER)
@@ -1893,7 +1885,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometryN'
;
create or replace function sedona.ST_GeometryType (geometry GEOMETRY)
@@ -1901,23 +1893,23 @@ returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometryType'
;
-create or replace function sedona.ST_HausdorffDistance (geom1 GEOMETRY, geom2 GEOMETRY)
+create or replace function sedona.ST_HausdorffDistance (geom1 GEOMETRY, geom2 GEOMETRY, densifyFrac DOUBLE)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_HausdorffDistance'
;
-create or replace function sedona.ST_HausdorffDistance (geom1 GEOMETRY, geom2 GEOMETRY, densifyFrac DOUBLE)
+create or replace function sedona.ST_HausdorffDistance (geom1 GEOMETRY, geom2 GEOMETRY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_HausdorffDistance'
;
create or replace function sedona.ST_InteriorRingN (geometry GEOMETRY, n NUMBER)
@@ -1925,7 +1917,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_InteriorRingN'
;
create or replace function sedona.ST_Intersection (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
@@ -1933,7 +1925,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Intersection'
;
create or replace function sedona.ST_Intersects (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
@@ -1941,7 +1933,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Intersects'
;
create or replace function sedona.ST_IsClosed (geometry GEOMETRY)
@@ -1949,7 +1941,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsClosed'
;
create or replace function sedona.ST_IsCollection (geometry GEOMETRY)
@@ -1957,7 +1949,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsCollection'
;
create or replace function sedona.ST_IsSimple (geometry GEOMETRY)
@@ -1965,23 +1957,23 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsSimple'
;
-create or replace function sedona.ST_IsValidReason (geometry GEOMETRY, flags NUMBER)
+create or replace function sedona.ST_IsValidReason (geometry GEOMETRY)
returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValidReason'
;
-create or replace function sedona.ST_IsValidReason (geometry GEOMETRY)
+create or replace function sedona.ST_IsValidReason (geometry GEOMETRY, flags NUMBER)
returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValidReason'
;
create or replace function sedona.ST_LineFromMultiPoint (geometry GEOMETRY)
@@ -1989,7 +1981,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineFromMultiPoint'
;
create or replace function sedona.ST_LineInterpolatePoint (geom GEOMETRY, fraction DOUBLE)
@@ -1997,7 +1989,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineInterpolatePoint'
;
create or replace function sedona.ST_LineLocatePoint (geom GEOMETRY, point GEOMETRY)
@@ -2005,7 +1997,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineLocatePoint'
;
create or replace function sedona.ST_LineMerge (geometry GEOMETRY)
@@ -2013,7 +2005,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineMerge'
;
create or replace function sedona.ST_LineSubstring (geom GEOMETRY, fromFraction DOUBLE, toFraction DOUBLE)
@@ -2021,7 +2013,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineSubstring'
;
create or replace function sedona.ST_MakeLine (geometryCollection GEOMETRY)
@@ -2029,7 +2021,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeLine'
;
create or replace function sedona.ST_MakeLine (point1 GEOMETRY, point2 GEOMETRY)
@@ -2037,7 +2029,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeLine'
;
create or replace function sedona.ST_MakePolygon (shell GEOMETRY, holes GEOMETRY)
@@ -2045,7 +2037,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakePolygon'
;
create or replace function sedona.ST_MakePolygon (shell GEOMETRY)
@@ -2053,23 +2045,23 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakePolygon'
;
-create or replace function sedona.ST_MakeValid (geometry GEOMETRY)
+create or replace function sedona.ST_MakeValid (geometry GEOMETRY, keepCollapsed BOOLEAN)
returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeValid'
;
-create or replace function sedona.ST_MakeValid (geometry GEOMETRY, keepCollapsed BOOLEAN)
+create or replace function sedona.ST_MakeValid (geometry GEOMETRY)
returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeValid'
;
create or replace function sedona.ST_MinimumBoundingCircle (geometry GEOMETRY, quadrantSegments NUMBER)
@@ -2077,7 +2069,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MinimumBoundingCircle'
;
create or replace function sedona.ST_Normalize (geometry GEOMETRY)
@@ -2085,7 +2077,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Normalize'
;
create or replace function sedona.ST_NumGeometries (geometry GEOMETRY)
@@ -2093,7 +2085,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NumGeometries'
;
create or replace function sedona.ST_NumInteriorRings (geometry GEOMETRY)
@@ -2101,7 +2093,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NumInteriorRings'
;
create or replace function sedona.ST_OrderingEquals (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
@@ -2109,7 +2101,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_OrderingEquals'
;
create or replace function sedona.ST_Overlaps (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
@@ -2117,7 +2109,7 @@ returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Overlaps'
;
create or replace function sedona.ST_PointOnSurface (geometry GEOMETRY)
@@ -2125,7 +2117,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_PointOnSurface'
;
create or replace function sedona.ST_PrecisionReduce (geometry GEOMETRY, precisionScale NUMBER)
@@ -2133,7 +2125,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_PrecisionReduce'
;
create or replace function sedona.ST_ReducePrecision (geometry GEOMETRY, precisionScale NUMBER)
@@ -2141,23 +2133,23 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ReducePrecision'
;
-create or replace function sedona.ST_RemovePoint (linestring GEOMETRY, position NUMBER)
+create or replace function sedona.ST_RemovePoint (linestring GEOMETRY)
returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_RemovePoint'
;
-create or replace function sedona.ST_RemovePoint (linestring GEOMETRY)
+create or replace function sedona.ST_RemovePoint (linestring GEOMETRY, position NUMBER)
returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_RemovePoint'
;
create or replace function sedona.ST_S2CellIDs (input GEOMETRY, level NUMBER)
@@ -2165,7 +2157,7 @@ returns ARRAY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_S2CellIDs'
;
create or replace function sedona.ST_SetPoint (linestring GEOMETRY, position NUMBER, point GEOMETRY)
@@ -2173,7 +2165,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SetPoint'
;
create or replace function sedona.ST_StartPoint (geometry GEOMETRY)
@@ -2181,7 +2173,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_StartPoint'
;
create or replace function sedona.ST_SubDivide (geometry GEOMETRY, maxVertices NUMBER)
@@ -2189,7 +2181,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SubDivide'
;
create or replace function sedona.ST_SymDifference (leftGeom GEOMETRY, rightGeom GEOMETRY)
@@ -2197,23 +2189,23 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SymDifference'
;
-create or replace function sedona.ST_Transform (geometry GEOMETRY, sourceCRS VARCHAR, targetCRS VARCHAR)
+create or replace function sedona.ST_Transform (geometry GEOMETRY, sourceCRS VARCHAR, targetCRS VARCHAR, lenient BOOLEAN)
returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Transform'
;
-create or replace function sedona.ST_Transform (geometry GEOMETRY, sourceCRS VARCHAR, targetCRS VARCHAR, lenient BOOLEAN)
+create or replace function sedona.ST_Transform (geometry GEOMETRY, sourceCRS VARCHAR, targetCRS VARCHAR)
returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Transform'
;
create or replace function sedona.ST_VoronoiPolygons (geometry GEOMETRY, tolerance DOUBLE, extent GEOMETRY)
@@ -2221,23 +2213,23 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_VoronoiPolygons'
;
-create or replace function sedona.ST_VoronoiPolygons (geometry GEOMETRY)
+create or replace function sedona.ST_VoronoiPolygons (geometry GEOMETRY, tolerance DOUBLE)
returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_VoronoiPolygons'
;
-create or replace function sedona.ST_VoronoiPolygons (geometry GEOMETRY, tolerance DOUBLE)
+create or replace function sedona.ST_VoronoiPolygons (geometry GEOMETRY)
returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_VoronoiPolygons'
;
create or replace function sedona.ST_AreaSpheroid (geometry GEOMETRY)
@@ -2245,23 +2237,23 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AreaSpheroid'
;
-create or replace function sedona.ST_DistanceSphere (geomA GEOMETRY, geomB GEOMETRY)
+create or replace function sedona.ST_DistanceSphere (geomA GEOMETRY, geomB GEOMETRY, radius DOUBLE)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DistanceSphere'
;
-create or replace function sedona.ST_DistanceSphere (geomA GEOMETRY, geomB GEOMETRY, radius DOUBLE)
+create or replace function sedona.ST_DistanceSphere (geomA GEOMETRY, geomB GEOMETRY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DistanceSphere'
;
create or replace function sedona.ST_DistanceSpheroid (geomA GEOMETRY, geomB GEOMETRY)
@@ -2269,7 +2261,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DistanceSpheroid'
;
create or replace function sedona.ST_FrechetDistance (geomA GEOMETRY, geomB GEOMETRY)
@@ -2277,7 +2269,7 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_FrechetDistance'
;
create or replace function sedona.ST_LengthSpheroid (geom GEOMETRY)
@@ -2285,23 +2277,23 @@ returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LengthSpheroid'
;
-create or replace function sedona.ST_GeometricMedian (geom GEOMETRY)
+create or replace function sedona.ST_GeometricMedian (geom GEOMETRY, tolerance FLOAT)
returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometricMedian'
;
-create or replace function sedona.ST_GeometricMedian (geom GEOMETRY, tolerance FLOAT)
+create or replace function sedona.ST_GeometricMedian (geom GEOMETRY)
returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometricMedian'
;
create or replace function sedona.ST_GeometricMedian (geom GEOMETRY, tolerance FLOAT, maxIter NUMBER)
@@ -2309,7 +2301,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometricMedian'
;
create or replace function sedona.ST_NumPoints (geom GEOMETRY)
@@ -2317,7 +2309,7 @@ returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NumPoints'
;
create or replace function sedona.ST_Translate (geom GEOMETRY, deltaX DOUBLE, deltaY DOUBLE)
@@ -2325,7 +2317,7 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Translate'
;
create or replace function sedona.ST_Translate (geom GEOMETRY, deltaX DOUBLE, deltaY DOUBLE, deltaZ DOUBLE)
@@ -2333,16 +2325,24 @@ returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Translate'
;
+create or replace function sedona.ST_SimplifyPreserveTopology (geometry GEOMETRY, distanceTolerance DOUBLE)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SimplifyPreserveTopology'
+;
-- UDTFs --
create or replace function sedona.ST_MinimumBoundingRadius (geom BINARY)
returns table(center BINARY, radius DOUBLE)
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.udtfs.ST_MinimumBoundingRadius'
;
create or replace function sedona.ST_InterSection_Aggr (geom BINARY)
@@ -2350,7 +2350,7 @@ returns table(intersected BINARY)
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.udtfs.ST_Intersection_Aggr'
;
create or replace function sedona.ST_SubDivideExplode (geom BINARY, maxVertices NUMBER)
@@ -2358,7 +2358,7 @@ returns table(geom BINARY)
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.udtfs.ST_SubDivideExplode'
;
create or replace function sedona.ST_Envelope_Aggr (geom BINARY)
@@ -2366,7 +2366,7 @@ returns table(envelope BINARY)
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.udtfs.ST_Envelope_Aggr'
;
create or replace function sedona.ST_Union_Aggr (geom BINARY)
@@ -2374,7 +2374,7 @@ returns table(unioned BINARY)
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.udtfs.ST_Union_Aggr'
;
create or replace function sedona.ST_Collect (geom BINARY)
@@ -2382,7 +2382,7 @@ returns table(collection BINARY)
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.udtfs.ST_Collect'
;
create or replace function sedona.ST_Dump (geomCollection BINARY)
@@ -2390,6 +2390,6 @@ returns table(geom BINARY)
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1-SNAPSHOT.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.udtfs.ST_Dump'
;
(sedona) 02/04: Change the next version to 1.6.0-SNAPSHOT
Posted by ji...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
jiayu pushed a commit to branch fix-docs-post-release
in repository https://gitbox.apache.org/repos/asf/sedona.git
commit f09d6cb1fcaf2c3e068c9b0c1d7157f76b582bea
Author: Jia Yu <ji...@apache.org>
AuthorDate: Sat Jan 13 21:07:25 2024 -0800
Change the next version to 1.6.0-SNAPSHOT
---
common/pom.xml | 2 +-
flink-shaded/pom.xml | 2 +-
flink/pom.xml | 2 +-
pom.xml | 2 +-
snowflake-tester/pom.xml | 2 +-
snowflake/pom.xml | 2 +-
spark-shaded/pom.xml | 2 +-
spark/common/pom.xml | 2 +-
spark/pom.xml | 2 +-
spark/spark-3.0/pom.xml | 2 +-
spark/spark-3.4/pom.xml | 2 +-
spark/spark-3.5/pom.xml | 2 +-
12 files changed, 12 insertions(+), 12 deletions(-)
diff --git a/common/pom.xml b/common/pom.xml
index 265c56739..feed4925b 100644
--- a/common/pom.xml
+++ b/common/pom.xml
@@ -22,7 +22,7 @@
<parent>
<groupId>org.apache.sedona</groupId>
<artifactId>sedona-parent</artifactId>
- <version>1.5.1-SNAPSHOT</version>
+ <version>1.6.0-SNAPSHOT</version>
<relativePath>../pom.xml</relativePath>
</parent>
<artifactId>sedona-common</artifactId>
diff --git a/flink-shaded/pom.xml b/flink-shaded/pom.xml
index b1d500a5d..de0b7281a 100644
--- a/flink-shaded/pom.xml
+++ b/flink-shaded/pom.xml
@@ -22,7 +22,7 @@
<parent>
<artifactId>sedona-parent</artifactId>
<groupId>org.apache.sedona</groupId>
- <version>1.5.1-SNAPSHOT</version>
+ <version>1.6.0-SNAPSHOT</version>
</parent>
<artifactId>sedona-flink-shaded_${scala.compat.version}</artifactId>
diff --git a/flink/pom.xml b/flink/pom.xml
index 5d115fa23..794d0d3cc 100644
--- a/flink/pom.xml
+++ b/flink/pom.xml
@@ -22,7 +22,7 @@
<parent>
<groupId>org.apache.sedona</groupId>
<artifactId>sedona-parent</artifactId>
- <version>1.5.1-SNAPSHOT</version>
+ <version>1.6.0-SNAPSHOT</version>
<relativePath>../pom.xml</relativePath>
</parent>
<artifactId>sedona-flink_${scala.compat.version}</artifactId>
diff --git a/pom.xml b/pom.xml
index 286134137..23a9d47a2 100644
--- a/pom.xml
+++ b/pom.xml
@@ -26,7 +26,7 @@
</parent>
<groupId>org.apache.sedona</groupId>
<artifactId>sedona-parent</artifactId>
- <version>1.5.1-SNAPSHOT</version>
+ <version>1.6.0-SNAPSHOT</version>
<packaging>pom</packaging>
<name>sedona-parent</name>
<url>http://sedona.apache.org/</url>
diff --git a/snowflake-tester/pom.xml b/snowflake-tester/pom.xml
index 9b9a1fff1..07a6538da 100644
--- a/snowflake-tester/pom.xml
+++ b/snowflake-tester/pom.xml
@@ -24,7 +24,7 @@
<parent>
<groupId>org.apache.sedona</groupId>
<artifactId>sedona-parent</artifactId>
- <version>1.5.1-SNAPSHOT</version>
+ <version>1.6.0-SNAPSHOT</version>
<relativePath>../pom.xml</relativePath>
</parent>
diff --git a/snowflake/pom.xml b/snowflake/pom.xml
index 1ef690e8c..72aa356d7 100644
--- a/snowflake/pom.xml
+++ b/snowflake/pom.xml
@@ -22,7 +22,7 @@
<parent>
<groupId>org.apache.sedona</groupId>
<artifactId>sedona-parent</artifactId>
- <version>1.5.1-SNAPSHOT</version>
+ <version>1.6.0-SNAPSHOT</version>
<relativePath>../pom.xml</relativePath>
</parent>
diff --git a/spark-shaded/pom.xml b/spark-shaded/pom.xml
index 3eb3f57e9..064e543a2 100644
--- a/spark-shaded/pom.xml
+++ b/spark-shaded/pom.xml
@@ -22,7 +22,7 @@
<parent>
<artifactId>sedona-parent</artifactId>
<groupId>org.apache.sedona</groupId>
- <version>1.5.1-SNAPSHOT</version>
+ <version>1.6.0-SNAPSHOT</version>
</parent>
<artifactId>sedona-spark-shaded-${spark.compat.version}_${scala.compat.version}</artifactId>
diff --git a/spark/common/pom.xml b/spark/common/pom.xml
index 2fea52e62..264fdf7ca 100644
--- a/spark/common/pom.xml
+++ b/spark/common/pom.xml
@@ -22,7 +22,7 @@
<parent>
<groupId>org.apache.sedona</groupId>
<artifactId>sedona-spark-parent-${spark.compat.version}_${scala.compat.version}</artifactId>
- <version>1.5.1-SNAPSHOT</version>
+ <version>1.6.0-SNAPSHOT</version>
<relativePath>../pom.xml</relativePath>
</parent>
<artifactId>sedona-spark-common-${spark.compat.version}_${scala.compat.version}</artifactId>
diff --git a/spark/pom.xml b/spark/pom.xml
index fba01f1f3..7226b1eb2 100644
--- a/spark/pom.xml
+++ b/spark/pom.xml
@@ -22,7 +22,7 @@
<parent>
<groupId>org.apache.sedona</groupId>
<artifactId>sedona-parent</artifactId>
- <version>1.5.1-SNAPSHOT</version>
+ <version>1.6.0-SNAPSHOT</version>
<relativePath>../pom.xml</relativePath>
</parent>
<artifactId>sedona-spark-parent-${spark.compat.version}_${scala.compat.version}</artifactId>
diff --git a/spark/spark-3.0/pom.xml b/spark/spark-3.0/pom.xml
index 3fa66a5cc..c3d86a832 100644
--- a/spark/spark-3.0/pom.xml
+++ b/spark/spark-3.0/pom.xml
@@ -22,7 +22,7 @@
<parent>
<groupId>org.apache.sedona</groupId>
<artifactId>sedona-spark-parent-${spark.compat.version}_${scala.compat.version}</artifactId>
- <version>1.5.1-SNAPSHOT</version>
+ <version>1.6.0-SNAPSHOT</version>
<relativePath>../pom.xml</relativePath>
</parent>
<artifactId>sedona-spark-3.0_${scala.compat.version}</artifactId>
diff --git a/spark/spark-3.4/pom.xml b/spark/spark-3.4/pom.xml
index f955b2cd7..786052b25 100644
--- a/spark/spark-3.4/pom.xml
+++ b/spark/spark-3.4/pom.xml
@@ -22,7 +22,7 @@
<parent>
<groupId>org.apache.sedona</groupId>
<artifactId>sedona-spark-parent-${spark.compat.version}_${scala.compat.version}</artifactId>
- <version>1.5.1-SNAPSHOT</version>
+ <version>1.6.0-SNAPSHOT</version>
<relativePath>../pom.xml</relativePath>
</parent>
<artifactId>sedona-spark-3.4_${scala.compat.version}</artifactId>
diff --git a/spark/spark-3.5/pom.xml b/spark/spark-3.5/pom.xml
index 4a0d42164..44dd5acd7 100644
--- a/spark/spark-3.5/pom.xml
+++ b/spark/spark-3.5/pom.xml
@@ -22,7 +22,7 @@
<parent>
<groupId>org.apache.sedona</groupId>
<artifactId>sedona-spark-parent-${spark.compat.version}_${scala.compat.version}</artifactId>
- <version>1.5.1-SNAPSHOT</version>
+ <version>1.6.0-SNAPSHOT</version>
<relativePath>../pom.xml</relativePath>
</parent>
<artifactId>sedona-spark-3.5_${scala.compat.version}</artifactId>
(sedona) 01/04: Update process
Posted by ji...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
jiayu pushed a commit to branch fix-docs-post-release
in repository https://gitbox.apache.org/repos/asf/sedona.git
commit 810ae437d18a2762b6804c3d083e79a96ea8c006
Author: Jia Yu <ji...@apache.org>
AuthorDate: Sat Jan 13 20:59:34 2024 -0800
Update process
---
docs/community/publish.md | 13 +++++++++++++
1 file changed, 13 insertions(+)
diff --git a/docs/community/publish.md b/docs/community/publish.md
index 31e58a0c7..a99e19e7c 100644
--- a/docs/community/publish.md
+++ b/docs/community/publish.md
@@ -94,6 +94,12 @@ mvn -q org.apache.maven.plugins:maven-release-plugin:2.3.2:perform -DconnectionU
# For Spark 3.4 and Scala 2.13
mvn -q org.apache.maven.plugins:maven-release-plugin:2.3.2:perform -DconnectionUrl=scm:git:https://github.com/apache/sedona.git -Dtag={{ sedona_create_release.current_git_tag }} -Dresume=false -Darguments="-DskipTests -Dspark=3.4 -Dscala=2.13" -Dspark=3.4 -Dscala=2.13
+# For Spark 3.5 and Scala 2.12
+mvn -q org.apache.maven.plugins:maven-release-plugin:2.3.2:perform -DconnectionUrl=scm:git:https://github.com/apache/sedona.git -Dtag={{ sedona_create_release.current_git_tag }} -Dresume=false -Darguments="-DskipTests -Dspark=3.5 -Dscala=2.12" -Dspark=3.4 -Dscala=2.12
+
+# For Spark 3.5 and Scala 2.13
+mvn -q org.apache.maven.plugins:maven-release-plugin:2.3.2:perform -DconnectionUrl=scm:git:https://github.com/apache/sedona.git -Dtag={{ sedona_create_release.current_git_tag }} -Dresume=false -Darguments="-DskipTests -Dspark=3.5 -Dscala=2.13" -Dspark=3.4 -Dscala=2.13
+
echo "*****Step 3: Upload Release Candidate on ASF SVN: https://dist.apache.org/repos/dist/dev/sedona"
echo "Creating {{ sedona_create_release.current_rc }} folder on SVN..."
@@ -119,6 +125,7 @@ mkdir apache-sedona-{{ sedona_create_release.current_version }}-bin
cd apache-sedona-{{ sedona_create_release.current_version }}-src && mvn -q clean install -DskipTests -Dspark=3.0 -Dscala=2.12 && cd ..
cp apache-sedona-{{ sedona_create_release.current_version }}-src/spark-shaded/target/sedona-*{{ sedona_create_release.current_version}}.jar apache-sedona-{{ sedona_create_release.current_version }}-bin/
cp apache-sedona-{{ sedona_create_release.current_version }}-src/flink-shaded/target/sedona-*{{ sedona_create_release.current_version}}.jar apache-sedona-{{ sedona_create_release.current_version }}-bin/
+cp apache-sedona-{{ sedona_create_release.current_version }}-src/snowflake/target/sedona-*{{ sedona_create_release.current_version}}.jar apache-sedona-{{ sedona_create_release.current_version }}-bin/
cd apache-sedona-{{ sedona_create_release.current_version }}-src && mvn -q clean install -DskipTests -Dspark=3.0 -Dscala=2.13 && cd ..
cp apache-sedona-{{ sedona_create_release.current_version }}-src/spark-shaded/target/sedona-*{{ sedona_create_release.current_version}}.jar apache-sedona-{{ sedona_create_release.current_version }}-bin/
@@ -129,6 +136,12 @@ cp apache-sedona-{{ sedona_create_release.current_version }}-src/spark-shaded/ta
cd apache-sedona-{{ sedona_create_release.current_version }}-src && mvn -q clean install -DskipTests -Dspark=3.4 -Dscala=2.13 && cd ..
cp apache-sedona-{{ sedona_create_release.current_version }}-src/spark-shaded/target/sedona-*{{ sedona_create_release.current_version}}.jar apache-sedona-{{ sedona_create_release.current_version }}-bin/
+cd apache-sedona-{{ sedona_create_release.current_version }}-src && mvn -q clean install -DskipTests -Dspark=3.5 -Dscala=2.12 && cd ..
+cp apache-sedona-{{ sedona_create_release.current_version }}-src/spark-shaded/target/sedona-*{{ sedona_create_release.current_version}}.jar apache-sedona-{{ sedona_create_release.current_version }}-bin/
+
+cd apache-sedona-{{ sedona_create_release.current_version }}-src && mvn -q clean install -DskipTests -Dspark=3.5 -Dscala=2.13 && cd ..
+cp apache-sedona-{{ sedona_create_release.current_version }}-src/spark-shaded/target/sedona-*{{ sedona_create_release.current_version}}.jar apache-sedona-{{ sedona_create_release.current_version }}-bin/
+
tar czf apache-sedona-{{ sedona_create_release.current_version }}-bin.tar.gz apache-sedona-{{ sedona_create_release.current_version }}-bin
shasum -a 512 apache-sedona-{{ sedona_create_release.current_version }}-src.tar.gz > apache-sedona-{{ sedona_create_release.current_version }}-src.tar.gz.sha512
shasum -a 512 apache-sedona-{{ sedona_create_release.current_version }}-bin.tar.gz > apache-sedona-{{ sedona_create_release.current_version }}-bin.tar.gz.sha512