8000 Issue #8265: AsOf Nested Loop by hawkfish · Pull Request #16218 · duckdb/duckdb · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Issue #8265: AsOf Nested Loop #16218

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 6 commits into from
Feb 14, 2025
Merged

Issue #8265: AsOf Nested Loop #16218

merged 6 commits into from
Feb 14, 2025

Conversation

hawkfish
Copy link
Contributor
  • For small probe cardinalities, plan a nested loop join + aggregate
  • Add asof_loop_join_threshold setting to control its use.
  • Add asof_loop_join_threshold loops to tests.
  • Set default asof_loop_join_threshold based on tuning tests.

Richard Wesley added 3 commits February 10, 2025 12:02
* For small probe cardinalities, plan a nested loop join + aggregate
* Add asof_loop_join_threshold setting to control its use.
* Add asof_loop_join_threshold loops to tests.
* Set default asof_loop_join_threshold based on tuning tests.
@hawkfish hawkfish requested a review from Mytherin February 12, 2025 22:29
* Fix ASCII art final baskslash silliness with an NBS...
@duckdb-draftbot duckdb-draftbot marked this pull request as draft February 12, 2025 23:35
@hawkfish hawkfish marked this pull request as ready for review February 12, 2025 23:56
* Make test deterministic
@duckdb-draftbot duckdb-draftbot marked this pull request as draft February 13, 2025 02:38
@hawkfish hawkfish marked this pull request as ready for review February 13, 2025 05:23
* Fix unique pointer cast
@duckdb-draftbot duckdb-draftbot marked this pull request as draft February 13, 2025 21:36
@Mytherin Mytherin marked this pull request as ready for review February 14, 2025 08:22
@Mytherin Mytherin merged commit 7d90767 into duckdb:main Feb 14, 2025
49 checks passed
@Mytherin
Copy link
Collaborator

Thanks!

@hawkfish hawkfish deleted the asof-loopjoin branch February 14, 2025 16:28
Antonov548 added a commit to Antonov548/duckdb-r that referenced this pull request Feb 27, 2025
Issue duckdb/duckdb#8265: AsOf Nested Loop (duckdb/duckdb#16218)
Fix -std=c++11 (duckdb/duckdb#16237)
Fix Python 3 executable name on Windows (duckdb/duckdb#16236)
Use _win32 with MSVC (duckdb/duckdb#16235)
Do In-Filter pushdown in PyArrow (duckdb/duckdb#16224)
krlmlr pushed a commit to duckdb/duckdb-r that referenced this pull request Mar 3, 2025
Issue duckdb/duckdb#8265: AsOf Nested Loop (duckdb/duckdb#16218)
Fix -std=c++11 (duckdb/duckdb#16237)
Fix Python 3 executable name on Windows (duckdb/duckdb#16236)
Use _win32 with MSVC (duckdb/duckdb#16235)
Do In-Filter pushdown in PyArrow (duckdb/duckdb#16224)
Antonov548 added a commit to Antonov548/duckdb-r that referenced this pull request Mar 4, 2025
Issue duckdb/duckdb#8265: AsOf Nested Loop (duckdb/duckdb#16218)
Fix -std=c++11 (duckdb/duckdb#16237)
Fix Python 3 executable name on Windows (duckdb/duckdb#16236)
Use _win32 with MSVC (duckdb/duckdb#16235)
Do In-Filter pushdown in PyArrow (duckdb/duckdb#16224)
krlmlr pushed a commit to duckdb/duckdb-r that referenced this pull request Mar 5, 2025
Issue duckdb/duckdb#8265: AsOf Nested Loop (duckdb/duckdb#16218)
Fix -std=c++11 (duckdb/duckdb#16237)
Fix Python 3 executable name on Windows (duckdb/duckdb#16236)
Use _win32 with MSVC (duckdb/duckdb#16235)
Do In-Filter pushdown in PyArrow (duckdb/duckdb#16224)
krlmlr pushed a commit to duckdb/duckdb-r that referenced this pull request Mar 5, 2025
Issue duckdb/duckdb#8265: AsOf Nested Loop (duckdb/duckdb#16218)
Fix -std=c++11 (duckdb/duckdb#16237)
Fix Python 3 executable name on Windows (duckdb/duckdb#16236)
Use _win32 with MSVC (duckdb/duckdb#16235)
Do In-Filter pushdown in PyArrow (duckdb/duckdb#16224)
krlmlr added a commit to duckdb/duckdb-r that referenced this pull request May 15, 2025
Issue duckdb/duckdb#8265: AsOf Nested Loop (duckdb/duckdb#16218)
Fix -std=c++11 (duckdb/duckdb#16237)
Fix Python 3 executable name on Windows (duckdb/duckdb#16236)
Use _win32 with MSVC (duckdb/duckdb#16235)
Do In-Filter pushdown in PyArrow (duckdb/duckdb#16224)
krlmlr added a commit to duckdb/duckdb-r that referenced this pull request May 15, 2025
Issue duckdb/duckdb#8265: AsOf Nested Loop (duckdb/duckdb#16218)
Fix -std=c++11 (duckdb/duckdb#16237)
Fix Python 3 executable name on Windows (duckdb/duckdb#16236)
Use _win32 with MSVC (duckdb/duckdb#16235)
Do In-Filter pushdown in PyArrow (duckdb/duckdb#16224)
krlmlr added a commit to duckdb/duckdb-r that referenced this pull request May 17, 2025
Issue duckdb/duckdb#8265: AsOf Nested Loop (duckdb/duckdb#16218)
Fix -std=c++11 (duckdb/duckdb#16237)
Fix Python 3 executable name on Windows (duckdb/duckdb#16236)
Use _win32 with MSVC (duckdb/duckdb#16235)
Do In-Filter pushdown in PyArrow (duckdb/duckdb#16224)
krlmlr added a commit to duckdb/duckdb-r that referenced this pull request May 18, 2025
Issue duckdb/duckdb#8265: AsOf Nested Loop (duckdb/duckdb#16218)
Fix -std=c++11 (duckdb/duckdb#16237)
Fix Python 3 executable name on Windows (duckdb/duckdb#16236)
Use _win32 with MSVC (duckdb/duckdb#16235)
Do In-Filter pushdown in PyArrow (duckdb/duckdb#16224)
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.

2 participants
0