[
https://issues.apache.org/jira/browse/HIVE-29726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Csaba Ringhofer updated HIVE-29726:
-----------------------------------
Description:
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.
was:
select st_intersects(st_geomfromtext('LINESTRING(0 0, 9 0, 0 9)'),
st_geomfromtext('MULTILINESTRING((1 10, 2 10), (10 10, 10 1))'));
The query above returns true in Hive, while it should return false.
Cross checked with postgis, which returns false.
Discover this when testing Apache Impala's new c++ implementation that used
boost::geometry, which also returns false.
> st_intersects incorrect with multlinestring
> -------------------------------------------
>
> Key: HIVE-29726
> URL: https://issues.apache.org/jira/browse/HIVE-29726
> Project: Hive
> Issue Type: Bug
> Reporter: Csaba Ringhofer
> Priority: Major
>
> 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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
