Hello
Im optmizing a big notebook and have encountered many times the tip from databricks that says "Unused range join hints". Reading the documentation for reference, I have been able to supress that warning in almost all cells, but some of then remains that I dont understand where to place the hint.
This problematic cells are of the same type (first cell of the image attached).
In the second cell there is no warning (i am using the same temp table in 1ยบ and 2ยบ cell) and that would mean that there is no problem building that dataset. That being said, I think the problem is in the INSERT INTO ..... REPLACE WHERE.
Where can I find documentation about the range_joins with the INSERT INTO REPLACE WHERE operation? The one I referenced talks only about joins, and here (insert into replace where doc) there is no clue either.
Any idea to optimize this operation also?
Thank you.
