You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sedona.apache.org by "andreypanchenko (via GitHub)" <gi...@apache.org> on 2024/03/25 11:56:39 UTC
[I] create or replace function sedona.* duplication [sedona]
andreypanchenko opened a new issue, #1291:
URL: https://github.com/apache/sedona/issues/1291
## Expected behavior
Each function after creation should have a unique name other hand it will be replaced with the next attempt.
I need ST_MakeValid with a false flag to avoid invalid records, but if I run the original file it will rewrite this function and `keepCollapsed` will not be available anymore.
```sql
create or replace function sedona.ST_MakeValid (geometry BINARY, keepCollapsed BOOLEAN)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.0-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakeValid'
;
create or replace function sedona.ST_MakeValid (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.0-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakeValid'
;
```
## Actual behavior
after creating an SQL file from the command `java -jar sedona-snowflake-1.5.1.jar --geotools-version 1.5.0-28.2 > sedona-snowflake.sql`
## Steps to reproduce the problem
java -jar sedona-snowflake-1.5.1.jar --geotools-version 1.5.0-28.2 > sedona-snowflake.sql
## Settings
Sedona version = sedona-snowflake-1.5.1.jar, geotools-wrapper-1.5.0-28.2.jar
API type = Java
Environment = Snowflake
[sedona-snowflake_fix.txt](https://github.com/apache/sedona/files/14742887/sedona-snowflake_fix.txt)
function name | occurance
-- | --
function sedona.ST_GeometricMedian | 7
function sedona.ST_GeometricMedian | 7
function sedona.ST_GeometricMedian | 7
function sedona.ST_GeometricMedian | 7
function sedona.ST_GeometricMedian | 7
function sedona.ST_GeometricMedian | 7
function sedona.ST_GeometricMedian | 7
function sedona.ST_VoronoiPolygons | 6
function sedona.ST_VoronoiPolygons | 6
function sedona.ST_VoronoiPolygons | 6
function sedona.ST_Angle | 6
function sedona.ST_Angle | 6
function sedona.ST_Angle | 6
function sedona.ST_VoronoiPolygons | 6
function sedona.ST_VoronoiPolygons | 6
function sedona.ST_VoronoiPolygons | 6
function sedona.ST_Angle | 6
function sedona.ST_Angle | 6
function sedona.ST_Angle | 6
function sedona.ST_CollectionExtract | 4
function sedona.ST_CollectionExtract | 4
function sedona.ST_HausdorffDistance | 4
function sedona.ST_HausdorffDistance | 4
function sedona.ST_IsValidReason | 4
function sedona.ST_IsValidReason | 4
function sedona.ST_DistanceSphere | 4
function sedona.ST_DistanceSphere | 4
function sedona.ST_Affine | 4
function sedona.ST_Affine | 4
function sedona.ST_ConcaveHull | 4
function sedona.ST_ConcaveHull | 4
function sedona.ST_IsValid | 4
function sedona.ST_IsValid | 4
function sedona.ST_MakeLine | 4
function sedona.ST_MakeLine | 4
function sedona.ST_MakePolygon | 4
function sedona.ST_MakePolygon | 4
function sedona.ST_MakeValid | 4
function sedona.ST_MakeValid | 4
function sedona.ST_RemovePoint | 4
function sedona.ST_RemovePoint | 4
function sedona.ST_Transform | 4
function sedona.ST_Transform | 4
function sedona.ST_Force3D | 4
function sedona.ST_Force3D | 4
function sedona.ST_Translate | 4
function sedona.ST_Translate | 4
function sedona.ST_CollectionExtract | 4
function sedona.ST_CollectionExtract | 4
function sedona.ST_HausdorffDistance | 4
function sedona.ST_HausdorffDistance | 4
function sedona.ST_IsValidReason | 4
function sedona.ST_IsValidReason | 4
function sedona.ST_DistanceSphere | 4
function sedona.ST_DistanceSphere | 4
function sedona.ST_Affine | 4
function sedona.ST_Affine | 4
function sedona.ST_ConcaveHull | 4
function sedona.ST_ConcaveHull | 4
function sedona.ST_IsValid | 4
function sedona.ST_IsValid | 4
function sedona.ST_MakeLine | 4
function sedona.ST_MakeLine | 4
function sedona.ST_MakePolygon | 4
function sedona.ST_MakePolygon | 4
function sedona.ST_MakeValid | 4
function sedona.ST_MakeValid | 4
function sedona.ST_RemovePoint | 4
function sedona.ST_RemovePoint | 4
function sedona.ST_Transform | 4
function sedona.ST_Transform | 4
function sedona.ST_Force3D | 4
function sedona.ST_Force3D | 4
function sedona.ST_Translate | 4
function sedona.ST_Translate | 4
function sedona.ST_MakePoint | 3
function sedona.ST_MakePoint | 3
function sedona.ST_MakePoint | 3
function sedona.ST_LineInterpolatePoint | 2
function sedona.ST_MinimumBoundingCircle | 2
function sedona.ST_SimplifyPreserveTopology | 2
function sedona.ST_BoundingDiagonal | 2
function sedona.ST_ClosestPoint | 2
function sedona.ST_ExteriorRing | 2
function sedona.ST_FlipCoordinates | 2
function sedona.ST_GeomFromText | 2
function sedona.ST_GeomFromText | 2
function sedona.ST_GeometryType | 2
function sedona.ST_InteriorRingN | 2
function sedona.ST_Intersection | 2
function sedona.ST_IsCollection | 2
function sedona.ST_LineFromMultiPoint | 2
function sedona.ST_LineLocatePoint | 2
function sedona.ST_LineSubstring | 2
function sedona.ST_MLineFromText | 2
function sedona.ST_MLineFromText | 2
function sedona.ST_MPolyFromText | 2
function sedona.ST_MPolyFromText | 2
function sedona.ST_NumGeometries | 2
function sedona.ST_NumInteriorRings | 2
function sedona.ST_OrderingEquals | 2
function sedona.ST_PointOnSurface | 2
function sedona.ST_PrecisionReduce | 2
function sedona.ST_ReducePrecision | 2
function sedona.ST_SymDifference | 2
function sedona.ST_AreaSpheroid | 2
function sedona.ST_DistanceSpheroid | 2
function sedona.ST_FrechetDistance | 2
function sedona.ST_LengthSpheroid | 2
function sedona.GeometryType | 2
function sedona.ST_AddPoint | 2
function sedona.ST_Area | 2
function sedona.ST_AsBinary | 2
function sedona.ST_AsEWKB | 2
function sedona.ST_AsEWKT | 2
function sedona.ST_AsGML | 2
function sedona.ST_AsGeoJSON | 2
function sedona.ST_AsKML | 2
function sedona.ST_Azimuth | 2
function sedona.ST_Boundary | 2
function sedona.ST_Buffer | 2
function sedona.ST_BuildArea | 2
function sedona.ST_Centroid | 2
function sedona.ST_Contains | 2
function sedona.ST_CoordDim | 2
function sedona.ST_ConvexHull | 2
function sedona.ST_CoveredBy | 2
function sedona.ST_Covers | 2
function sedona.ST_Crosses | 2
function sedona.ST_Difference | 2
function sedona.ST_Dimension | 2
function sedona.ST_Disjoint | 2
function sedona.ST_Distance | 2
function sedona.ST_3DDistance | 2
function sedona.ST_DumpPoints | 2
function sedona.ST_EndPoint | 2
function sedona.ST_Envelope | 2
function sedona.ST_Equals | 2
function sedona.ST_Force_2D | 2
function sedona.ST_Force2D | 2
function sedona.ST_GeoHash | 2
function sedona.ST_GeomFromWKT | 2
function sedona.ST_GeomFromWKT | 2
function sedona.ST_GeometryN | 2
function sedona.ST_Intersects | 2
function sedona.ST_IsClosed | 2
function sedona.ST_IsEmpty | 2
function sedona.ST_IsRing | 2
function sedona.ST_IsSimple | 2
function sedona.ST_Length | 2
function sedona.ST_LineMerge | 2
function sedona.ST_Multi | 2
function sedona.ST_NDims | 2
function sedona.ST_NPoints | 2
function sedona.ST_Normalize | 2
function sedona.ST_Overlaps | 2
function sedona.ST_PointN | 2
function sedona.ST_PointZ | 2
function sedona.ST_PointZ | 2
function sedona.ST_Polygon | 2
function sedona.ST_Reverse | 2
function sedona.ST_S2CellIDs | 2
function sedona.ST_SRID | 2
function sedona.ST_AsText | 2
function sedona.ST_SetPoint | 2
function sedona.ST_SetSRID | 2
function sedona.ST_Split | 2
function sedona.ST_StartPoint | 2
function sedona.ST_SubDivide | 2
function sedona.ST_Touches | 2
function sedona.ST_Union | 2
function sedona.ST_Within | 2
function sedona.ST_XMax | 2
function sedona.ST_XMin | 2
function sedona.ST_YMax | 2
function sedona.ST_YMin | 2
function sedona.ST_ZMax | 2
function sedona.ST_ZMin | 2
function sedona.ST_DWithin | 2
function sedona.ST_NRings | 2
function sedona.ST_NumPoints | 2
function sedona.ST_X | 2
function sedona.ST_Y | 2
function sedona.ST_Z | 2
function sedona.ST_LineInterpolatePoint | 2
function sedona.ST_MinimumBoundingCircle | 2
function sedona.ST_SimplifyPreserveTopology | 2
function sedona.ST_BoundingDiagonal | 2
function sedona.ST_ClosestPoint | 2
function sedona.ST_ExteriorRing | 2
function sedona.ST_FlipCoordinates | 2
function sedona.ST_GeometryType | 2
function sedona.ST_InteriorRingN | 2
function sedona.ST_Intersection | 2
function sedona.ST_IsCollection | 2
function sedona.ST_LineFromMultiPoint | 2
function sedona.ST_LineLocatePoint | 2
function sedona.ST_LineSubstring | 2
function sedona.ST_NumGeometries | 2
function sedona.ST_NumInteriorRings | 2
function sedona.ST_OrderingEquals | 2
function sedona.ST_PointOnSurface | 2
function sedona.ST_PrecisionReduce | 2
function sedona.ST_ReducePrecision | 2
function sedona.ST_SymDifference | 2
function sedona.ST_AreaSpheroid | 2
function sedona.ST_DistanceSpheroid | 2
function sedona.ST_FrechetDistance | 2
function sedona.ST_LengthSpheroid | 2
function sedona.GeometryType | 2
function sedona.ST_AddPoint | 2
function sedona.ST_Area | 2
function sedona.ST_AsBinary | 2
function sedona.ST_AsEWKB | 2
function sedona.ST_AsEWKT | 2
function sedona.ST_AsGML | 2
function sedona.ST_AsGeoJSON | 2
function sedona.ST_AsKML | 2
function sedona.ST_Azimuth | 2
function sedona.ST_Boundary | 2
function sedona.ST_Buffer | 2
function sedona.ST_BuildArea | 2
function sedona.ST_Centroid | 2
function sedona.ST_Contains | 2
function sedona.ST_CoordDim | 2
function sedona.ST_ConvexHull | 2
function sedona.ST_CoveredBy | 2
function sedona.ST_Covers | 2
function sedona.ST_Crosses | 2
function sedona.ST_Difference | 2
function sedona.ST_Dimension | 2
function sedona.ST_Disjoint | 2
function sedona.ST_Distance | 2
function sedona.ST_3DDistance | 2
function sedona.ST_DumpPoints | 2
function sedona.ST_EndPoint | 2
function sedona.ST_Envelope | 2
function sedona.ST_Equals | 2
function sedona.ST_Force_2D | 2
function sedona.ST_Force2D | 2
function sedona.ST_GeoHash | 2
function sedona.ST_GeometryN | 2
function sedona.ST_Intersects | 2
function sedona.ST_IsClosed | 2
function sedona.ST_IsEmpty | 2
function sedona.ST_IsRing | 2
function sedona.ST_IsSimple | 2
function sedona.ST_Length | 2
function sedona.ST_LineMerge | 2
function sedona.ST_Multi | 2
function sedona.ST_NDims | 2
function sedona.ST_NPoints | 2
function sedona.ST_Normalize | 2
function sedona.ST_Overlaps | 2
function sedona.ST_PointN | 2
function sedona.ST_Polygon | 2
function sedona.ST_Reverse | 2
function sedona.ST_S2CellIDs | 2
function sedona.ST_SRID | 2
function sedona.ST_AsText | 2
function sedona.ST_SetPoint | 2
function sedona.ST_SetSRID | 2
function sedona.ST_Split | 2
function sedona.ST_StartPoint | 2
function sedona.ST_SubDivide | 2
function sedona.ST_Touches | 2
function sedona.ST_Union | 2
function sedona.ST_Within | 2
function sedona.ST_XMax | 2
function sedona.ST_XMin | 2
function sedona.ST_YMax | 2
function sedona.ST_YMin | 2
function sedona.ST_ZMax | 2
function sedona.ST_ZMin | 2
function sedona.ST_DWithin | 2
function sedona.ST_NRings | 2
function sedona.ST_NumPoints | 2
function sedona.ST_X | 2
function sedona.ST_Y | 2
function sedona.ST_Z | 2
function sedona.ST_GeomFromGeoHash | 1
function sedona.ST_GeomFromGeoJSON | 1
function sedona.ST_LineFromText | 1
function sedona.ST_LineStringFromText | 1
function sedona.ST_PointFromText | 1
function sedona.ST_PolygonFromEnvelope | 1
function sedona.ST_PolygonFromText | 1
function sedona.ST_Degrees | 1
function sedona.ST_GeomFromGML | 1
function sedona.ST_GeomFromKML | 1
function sedona.ST_GeomFromWKB | 1
function sedona.ST_Point | 1
function sedona.ST_MinimumBoundingRadius | 1
function sedona.ST_InterSection_Aggr | 1
function sedona.ST_SubDivideExplode | 1
function sedona.ST_Envelope_Aggr | 1
function sedona.ST_Union_Aggr | 1
function sedona.ST_Collect | 1
function sedona.ST_Dump | 1
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@sedona.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] create or replace function sedona.* duplication [sedona]
Posted by "andreypanchenko (via GitHub)" <gi...@apache.org>.
andreypanchenko closed issue #1291: create or replace function sedona.* duplication
URL: https://github.com/apache/sedona/issues/1291
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@sedona.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org