Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

create or replace function sedona.* duplication #1291

Closed
andreypanchenko opened this issue Mar 25, 2024 · 0 comments
Closed

create or replace function sedona.* duplication #1291

andreypanchenko opened this issue Mar 25, 2024 · 0 comments

Comments

@andreypanchenko
Copy link

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.

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

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@andreypanchenko