[jira] [Created] (SEDONA-192) Null handling in predicates

2022-11-12 Thread Tanel Kiis (Jira)
Tanel Kiis created SEDONA-192:
-

 Summary: Null handling in predicates
 Key: SEDONA-192
 URL: https://issues.apache.org/jira/browse/SEDONA-192
 Project: Apache Sedona
  Issue Type: Improvement
Reporter: Tanel Kiis


ST_Predicate should allow nulls as inputs and outputs



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (SEDONA-191) Support join types other than inner in BroadcastIndexJoinExec

2022-11-11 Thread Tanel Kiis (Jira)
Tanel Kiis created SEDONA-191:
-

 Summary: Support join types other than inner in 
BroadcastIndexJoinExec
 Key: SEDONA-191
 URL: https://issues.apache.org/jira/browse/SEDONA-191
 Project: Apache Sedona
  Issue Type: Improvement
Reporter: Tanel Kiis






--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (SEDONA-189) Using prepared geometries

2022-11-04 Thread Tanel Kiis (Jira)
Tanel Kiis created SEDONA-189:
-

 Summary: Using prepared geometries
 Key: SEDONA-189
 URL: https://issues.apache.org/jira/browse/SEDONA-189
 Project: Apache Sedona
  Issue Type: Improvement
Reporter: Tanel Kiis


With complex polygons using prepared geometries can improve query performance 
by an order of magnitude.

A test, where I had 1M points and 5k polygons, a simple broadcast join and 
count with ST_Contains had a performance increase from 1m 20s down to 10s (8x 
improvement). 





--
This message was sent by Atlassian Jira
(v8.20.10#820010)