Tochilkin Misha
Tochilkin Misha
@chadwilcomb @korbel-jacek I had a same problem with join, but fixed it with some properties (table + sessions) and custom rule. It's workaround - not final solution. Need patch source...
@milleniax your understanding is right. You can avoid two full scan only if you change query / change source table structure.
@cloud-fan check PR, please. This patch speed up SPJ - test in Iceberg, gain +10-15% performance (avoid sort/shuffle in already sorted tables).