Jason Fehr created IMPALA-15193:
-----------------------------------
Summary: st_intersects incorrect with multlinestring
Key: IMPALA-15193
URL: https://issues.apache.org/jira/browse/IMPALA-15193
Project: IMPALA
Issue Type: Bug
Reporter: Jason Fehr
Assignee: Jason Fehr
select st_intersects(st_geomfromtext('LINESTRING(1 0, 1 1)'),
st_geomfromtext('MULTILINESTRING((0 0, 0 1), (2 0, 2 1))'));
The x coordinate is 1 in the linestring, while 0 and 2 own the multilinestring,
so they obviously don't intersect.
The query above returns true in Hive.
Cross checked with postgis, which returns false.
Discovered this when testing Apache Impala's new c++ implementation that used
boost::geometry, which also returns false.
The following query also returns true when it should return false:
select st_intersects(st_geomfromtext('MULTILINESTRING((2 0, 2 2),(3 0, 3 2))'),
st_geomfromtext('MULTILINESTRING((0 0, 0 2), (4 0, 4 2))'));
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
