Sebastian Eckweiler created SEDONA-60:
-----------------------------------------
Summary: Failing join if one side has only one row
Key: SEDONA-60
URL: https://issues.apache.org/jira/browse/SEDONA-60
Project: Apache Sedona
Issue Type: Improvement
Reporter: Sebastian Eckweiler
We came across an issue when trying to join a one-row dataframe with another
(with more rows).
Example:
{code:java}
left = spark.sql("SELECT St_PolygonFromText('1,1,1,0,0,0,0,1,1,1', ',') as
polygon")
right = spark.createDataFrame([(x,) for x in range(100)],
schema=["x"]).selectExpr("St_Point(x,x) as point")
left.createOrReplaceTempView("left")
right.createOrReplaceTempView("right")
spark.sql("SELECT * FROM left JOIN right ON ST_Intersects(left.polygon,
right.point)").count()
{code}
Produces:
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
