Posted by
Ajantha Bhat on
Apr 19, 2021; 2:20pm
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/DISCUSSION-Support-JOIN-query-with-spatial-index-tp107159p107698.html
Hi,
I think now the latest document has addressed my previous comments and
questions.
polygon list query and polyline list query design looks ok.
But the design of polygon query with join, I have performance concern.
In this approach, we are using union polygon filter on spatial_table to
prune till blocklet.
It may identify all the rows in blocklet in the worst case and with this
output (N) we will perform join with the polygon table output(M).
which will again check IN_POLYGON condition during join (N*M) times. I too
don't have any different solution at the moment.
But we can optimize the current solution further by below points:
a) Here for the polygon table output you can reduce making quadtree for N*M
times to M times and use the quadtree output as range filter/UDF for join.
b) Also later if we need more improvement, maybe we can try row-level
filtering on the spatial table.
Thanks,
Ajantha
On Thu, Apr 15, 2021 at 9:37 PM Indhumathi <
[hidden email]> wrote: