gustavodemorais commented on code in PR #27271:
URL: https://github.com/apache/flink/pull/27271#discussion_r2564595215
##########
docs/content/docs/dev/table/sql/queries/hints.md:
##########
@@ -279,6 +279,49 @@ SELECT /*+ NEST_LOOP(t1) */ * FROM t1 JOIN t2 ON t1.id =
t2.id;
SELECT /*+ NEST_LOOP(t1, t3) */ * FROM t1 JOIN t2 ON t1.id = t2.id JOIN t3 ON
t1.id = t3.id;
```
+#### MULTI_JOIN
+
+{{< label Streaming >}}
+
+`MULTI_JOIN` suggests that Flink uses the `MultiJoin operator` to process
multiple regular joins simultaneously. This type of join hint is recommended
when you have multiple joins that share at least one common join key and
experience large intermediate state or record amplification. The MultiJoin
operator eliminates intermediate state by processing joins across various input
streams simultaneously, which can significantly reduce state size and improve
performance in some cases.
+
+For more details on the MultiJoin operator, including when to use it and
configuration options, see [Multiple Regular Joins]({{< ref
"docs/dev/table/tuning" >}}#multiple-regular-joins).
+
+{{< hint info >}}
+Note:
+- The MULTI_JOIN hint can specify table names or table aliases. If a table has
an alias, the hint must use the alias name.
Review Comment:
I've opened another PR so we add this as a small note
https://github.com/apache/flink/pull/27277/files
--
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]
