apache / apache/datafusion

Enable datafusion.optimizer.filter_null_join_keys by default

Open
#12,375 0 comments 0 reactions 0 assignees View on GitHub
enhancement performance
Dominant language
Rust
Stars
9.3k
Forks
2.4k
Avg merge
3d 7h
Merged PRs (30d)
344

Description

### Is your feature request related to a problem or challenge?

It is better to have `FilterNullJoinKeys` enabled by default, as pushing a filter down below a join is generally faster than the overhead saved by not having to execute the null filter.
Besides that, in many cases the filter can be pushed down further to the scan or might enable other optimizations (now or future ones).

### Describe the solution you'd like

_No response_

### Describe alternatives you've considered

_No response_

### Additional context

_No response_

Contributor guide

Open the contributing guide

Research direction

Start by locating the `datafusion.optimizer.filter_null_join_keys` setting and the `FilterNullJoinKeys` optimizer rule. Verify how the default is defined and how optimizer behavior is tested; done means the rule is enabled by default and existing or added tests confirm the resulting join-key filtering behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
rust
Domain
databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.