Skip to content

Conversation

@walterddr
Copy link
Contributor

@walterddr walterddr commented Sep 27, 2023

there's no reason not to enable dynamic broadcast for SEMI joins at the current status of multi-stage,
except for the situation where the right table is so large and the left table is not partitioned. in which case we have a fallback option to enable hash table join joinOptions(join_strategy = 'hash_table')

@walterddr walterddr added the multi-stage Related to the multi-stage query engine label Sep 27, 2023
@codecov-commenter
Copy link

codecov-commenter commented Sep 27, 2023

Codecov Report

✅ All modified and coverable lines are covered by tests.
✅ Project coverage is 63.05%. Comparing base (1f93870) to head (c339fea).
⚠️ Report is 3391 commits behind head on master.

Additional details and impacted files
@@             Coverage Diff              @@
##             master   #11696      +/-   ##
============================================
- Coverage     63.10%   63.05%   -0.05%     
- Complexity     1120     1121       +1     
============================================
  Files          2343     2343              
  Lines        125672   125672              
  Branches      19317    19317              
============================================
- Hits          79309    79248      -61     
- Misses        40705    40773      +68     
+ Partials       5658     5651       -7     
Flag Coverage Δ
integration <0.01% <ø> (ø)
integration1 <0.01% <ø> (ø)
integration2 0.00% <ø> (ø)
java-11 63.02% <ø> (-0.04%) ⬇️
java-17 62.91% <ø> (-0.02%) ⬇️
java-20 62.92% <ø> (-0.01%) ⬇️
temurin 63.05% <ø> (-0.05%) ⬇️
unittests 63.05% <ø> (-0.05%) ⬇️
unittests1 67.21% <ø> (-0.02%) ⬇️
unittests2 14.44% <ø> (-0.05%) ⬇️

Flags with carried forward coverage won't be shown. Click here to find out more.

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

🚀 New features to boost your workflow:
  • 📦 JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

&& PinotRuleUtils.noExchangeInSubtree(left.getInput(0))
&& (join.getJoinType() == JoinRelType.SEMI && joinInfo.nonEquiConditions.isEmpty());
// default enable dynamic broadcast for SEMI join unless other join strategy were specified
&& (!explicitOtherStrategy && join.getJoinType() == JoinRelType.SEMI && joinInfo.nonEquiConditions.isEmpty());
Copy link
Contributor

Choose a reason for hiding this comment

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

Is dynamic broadcast useful for non-SEMI join? Currently it won't be applied even if we explicitly hint about it

Copy link
Contributor Author

Choose a reason for hiding this comment

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

it can be in the future. currently it will only apply to SEMI join

@walterddr walterddr merged commit 0e24863 into apache:master Sep 27, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

documentation enhancement multi-stage Related to the multi-stage query engine

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants