Re: [DISCUSSION] Support JOIN query with spatial index

Posted by Indhumathi on Apr 27, 2021; 10:29am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/DISCUSSION-Support-JOIN-query-with-spatial-index-tp107159p107950.html

Thanks Ajantha for your inputs.

I have modified the design, by adding ToRangeList Udf filter as a implicit
column projection to the polygon table dataframe and modified the JOIN
condition with range list udf column, in order to improve performance.

By this way, we can avoid making quadtree from N*M times to M times.
I have attached new design document in the JIRA.
CARBONDATA-4166 <https://issues.apache.org/jira/browse/CARBONDATA-4166>  

Regards,
Indhumathi



--
Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/