magellan icon indicating copy to clipboard operation
magellan copied to clipboard

Published 20 hours ago • verified publisher icon harsha2010

Extend Spatial Joins to more types of Joins

Open harsha2010 opened this issue 7 years ago • 3 comments

Apart from Inner Joins, also support Left Outer/ Right Outer Joins using Spatial Indices. eg. points.join(polygons, $"point" within $"polygon", "leftouter | rightouter") should also leverage spatial indices.

harsha2010 avatar Aug 17 '17 00:08 harsha2010

@Perados I created a ticket to track the left outer join optimization we discussed. Will have an ETA soon

harsha2010 avatar Aug 17 '17 00:08 harsha2010

@harsha2010 Thank you very much! My solution works for now, so there is no hurry, at least on my side. But yeah, this would be very useful for users in general. 👍

Perados avatar Aug 17 '17 08:08 Perados

@harsha2010 are you also considering to implement using spatial index while there will be multiple join conditions?

obaidcuet avatar Oct 05 '17 12:10 obaidcuet