ok. +1 from my side. If polygon join query still has performance bottleneck, we can later optimize it.
Thanks, Ajantha On Tue, Apr 27, 2021 at 3:59 PM Indhumathi <indhumathi...@gmail.com> wrote: > 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/ >