vtlim commented on code in PR #18027: URL: https://github.com/apache/druid/pull/18027#discussion_r2125160299
########## docs/multi-stage-query/reference.md: ########## @@ -501,10 +506,11 @@ When using the sort-merge algorithm, keep the following in mind: - All join types are supported with `sortMerge`: LEFT, RIGHT, INNER, FULL, and CROSS. -The following example runs using a single sort-merge join stage that receives `eventstream` -(partitioned on `user_id`) and `users` (partitioned on `id`) as inputs. There is no limit on the size of either input. +The following example shows a single sort-merge join stage where it explicitly set `sqlJoinAlgorithm` to `sortMerge` using the SET command. This query also takes `eventstream` (partitioned on `user_id`) and `users` (partitioned on id) as `inputs`, with no limit on the size of either input. Review Comment: ```suggestion The following query runs a single sort-merge join stage that takes the following inputs: * `eventstream` partitioned on `user_id` * `users` partitioned on `id` There is no limit on the size of either input. The SET command assigns the `sqlJoinAlgorithm` context parameter so that Druid uses the sort-merge join algorithm for the query. ``` -- 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]
