Monthly Summary - 2026-03 Overview: - Focused on expanding dynamic filter pushdown for hash joins within spiceai/datafusion. Extended support to additional join types that preserve the probe side, enabling more aggressive filtering and improved query efficiency for analytical workloads. Key deliverables: - Dynamic Filter Pushdown Enhancements for Hash Joins: Extended dynamic filters to Left, LeftSemi, RightSemi, LeftAnti, and LeftMark joins by promoting on_lr_is_preserved to the JoinType, enabling more flexible and efficient pushdown. - Stability and testing: Ensured changes are tested and aligned with the refactor of the join filter pushdown infrastructure. - Alignment with strategic goals: Progress toward resolving performance-related issues in complex hash-join scenarios (e.g., issue #16973). Impact: - Business value: Reduced data scanned and lower latency for complex join queries, contributing to faster analytics and lower compute costs. - Technical impact: Broader applicability of dynamic filters across common join patterns, with improved correctness and maintainability through infrastructure refactor. Technologies/skills demonstrated: - HashJoinExec dynamic filtering logic, JoinType and on_lr_is_preserved semantics - Join filter pushdown refactor and test coverage - PR-driven collaboration and issue tracking (closes #16973)