ulysses-you commented on a change in pull request #34069:
URL: https://github.com/apache/spark/pull/34069#discussion_r714417205
##########
File path: docs/sql-ref-syntax-qry-select-hints.md
##########
@@ -126,6 +126,10 @@ Join hints allow users to suggest the join strategy that
Spark should use. Prior
Suggests that Spark use shuffle-and-replicate nested loop join.
+* **BROADCAST_NL**
+
+ Suggests that Spark use broadcast nested loop join. The join side with the
hint will be broadcast regardless of `autoBroadcastJoinThreshold`. If both
sides of the join have the broadcast hints, the one with the smaller size
(based on stats) will be broadcast. Note that, this hint is only useful if the
join type and build side is not supported by hash join. i.e. full outer join,
left outer/semi/anti join with build left, right outer join with build right.
+
Review comment:
it should be broadcast hash join, let me make it clear
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
