Skip to content

Internal #5380: AsOf Join Pipeline #19169

Merged
hannes merged 9 commits into
duckdb:mainfrom
hawkfish:asof-pipeline
Sep 30, 2025
Merged

Internal #5380: AsOf Join Pipeline #19169
hannes merged 9 commits into
duckdb:mainfrom
hawkfish:asof-pipeline

Conversation

@hawkfish
Copy link
Copy Markdown
Member

  • Implement double pipeline breaker version
  • Move join key filtering to GetData
  • Handle all left join conditions

Richard Wesley added 7 commits September 25, 2025 14:14
* Checkpoint commit for double pipeline breaker version
* Fix left_group computation
* Fix is_outer initialisation
* Move join key filtering to GetData
* Handle all left join conditions
@hawkfish
Copy link
Copy Markdown
Member Author

@lnkuiper figured you should look at this so you have some background for the eventual sorting rewrite?

Copy link
Copy Markdown
Member

@lnkuiper lnkuiper left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks for the PR! I just have one concern:

Comment thread src/execution/operator/join/physical_asof_join.cpp
* Make Finalize match the other double pipeline breaker (IEJoin)
* Add test to be sure (it was fine without the change, but future proofing seems smart)
@duckdb-draftbot duckdb-draftbot marked this pull request as draft September 29, 2025 18:59
@hawkfish hawkfish marked this pull request as ready for review September 29, 2025 19:37
Copy link
Copy Markdown
Member

@lnkuiper lnkuiper left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks for adding the test! LGTM now

@hannes
Copy link
Copy Markdown
Member

hannes commented Sep 30, 2025

Thanks!

@hannes hannes merged commit cdb1995 into duckdb:main Sep 30, 2025
98 checks passed
@hawkfish hawkfish deleted the asof-pipeline branch September 30, 2025 22:17
krlmlr added a commit to krlmlr/duckdb-r that referenced this pull request Oct 21, 2025
krlmlr added a commit to krlmlr/duckdb-r that referenced this pull request Nov 1, 2025
krlmlr added a commit to krlmlr/duckdb-r that referenced this pull request Nov 2, 2025
krlmlr added a commit to krlmlr/duckdb-r that referenced this pull request Nov 2, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants