huaxingao commented on a change in pull request #28428:
URL: https://github.com/apache/spark/pull/28428#discussion_r418437458
##########
File path: docs/sql-ref-syntax-qry-select-hints.md
##########
@@ -78,7 +84,7 @@ SELECT /*+ SHUFFLE_REPLICATE_NL(t1) */ * FROM t1 INNER JOIN
t2 ON t1.key = t2.ke
-- Spark will issue Warning in the following example
-- org.apache.spark.sql.catalyst.analysis.HintErrorLogger: Hint
(strategy=merge)
-- is overridden by another hint and will not take effect.
-SELECT /*+ BROADCAST(t1) */ /*+ MERGE(t1, t2) */ * FROM t1 INNER JOIN t2 ON
t1.key = t2.key;
+SELECT /*+ BROADCAST(t1), MERGE(t1, t2) */ * FROM t1 INNER JOIN t2 ON t1.key =
t2.key;
Review comment:
```SELECT /*+ BROADCAST(t1) */ /*+ MERGE(t1, t2) */``` works too, but
want to make the example consistent with the syntax ```/*+ join_hint [ , ... ]
*/```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
