Impala Public Jenkins has submitted this change and it was merged. ( http://gerrit.cloudera.org:8080/24601 )
Change subject: IMPALA-15193: ST_Intersects Incorrect Results Workaround ...................................................................... IMPALA-15193: ST_Intersects Incorrect Results Workaround Workaround of a bug in the ST_Intersects built-in UDF caused by a bug in the underpinning esri-geometry-api library. This bug results in true being returned when comparing either a LineString or a MultiLineString with another MultiLineString. If the first geometry is within the envelope of the second MutlLineString, then true is returned even if the two geometries do not actually intersect. Tested via the addition of new query tests with the test results double checked in postgis. Assisted-by: Github Copilot (GPT-5.3-Codex) Change-Id: I62315574ca7cac2e71f3d301abbc9f0088b6533d Reviewed-on: http://gerrit.cloudera.org:8080/24601 Reviewed-by: Impala Public Jenkins <[email protected]> Tested-by: Impala Public Jenkins <[email protected]> --- M java/hive-geospatial-functions/src/main/java/org/apache/impala/hive/geospatial/esri/ST_GeometryRelational.java M java/hive-geospatial-functions/src/main/java/org/apache/impala/hive/geospatial/esri/ST_Intersects.java M testdata/workloads/functional-query/queries/QueryTest/geospatial-esri-extra.test 3 files changed, 78 insertions(+), 2 deletions(-) Approvals: Impala Public Jenkins: Looks good to me, approved; Verified -- To view, visit http://gerrit.cloudera.org:8080/24601 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-MessageType: merged Gerrit-Change-Id: I62315574ca7cac2e71f3d301abbc9f0088b6533d Gerrit-Change-Number: 24601 Gerrit-PatchSet: 5 Gerrit-Owner: Jason Fehr <[email protected]> Gerrit-Reviewer: Csaba Ringhofer <[email protected]> Gerrit-Reviewer: Impala Public Jenkins <[email protected]> Gerrit-Reviewer: Jason Fehr <[email protected]>
