You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@spark.apache.org by GitBox <gi...@apache.org> on 2020/04/03 16:22:10 UTC

[GitHub] [spark] huaxingao opened a new pull request #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

huaxingao opened a new pull request #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113
 
 
   
   ### What changes were proposed in this pull request?
   Document Join Hints
   
   
   ### Why are the changes needed?
   To make SQL Reference complete
   
   
   ### Does this PR introduce any user-facing change?
   Yes
   
   <img width="1049" alt="Screen Shot 2020-04-03 at 9 20 15 AM" src="https://user-images.githubusercontent.com/13592258/78382976-7c546b80-758c-11ea-9a8e-e46cfb7106f5.png">
   
   <img width="1050" alt="Screen Shot 2020-04-03 at 9 20 29 AM" src="https://user-images.githubusercontent.com/13592258/78382984-7eb6c580-758c-11ea-87ea-f9a8eeb32260.png">
   
   
   
   ### How was this patch tested?
   Manually build and check
   
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] srowen commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
srowen commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-609814610
 
 
   Merged to master/3.0

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] SparkQA commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
SparkQA commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608535843
 
 
   **[Test build #120783 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/120783/testReport)** for PR 28113 at commit [`0d2e92e`](https://github.com/apache/spark/commit/0d2e92eee6d8cd0b580755183cde50bdbbb0219f).

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608543080
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608605573
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608582332
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/120785/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] SparkQA commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
SparkQA commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608576003
 
 
   **[Test build #120785 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/120785/testReport)** for PR 28113 at commit [`1ae78d8`](https://github.com/apache/spark/commit/1ae78d85f7e902314a9be6e01696d7fe6abcb7f1).

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] SparkQA removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
SparkQA removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608599856
 
 
   **[Test build #120788 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/120788/testReport)** for PR 28113 at commit [`43672db`](https://github.com/apache/spark/commit/43672dbccbb08df076db861663e71b0e382277c0).

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608605583
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/120788/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] SparkQA commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
SparkQA commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608599856
 
 
   **[Test build #120788 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/120788/testReport)** for PR 28113 at commit [`43672db`](https://github.com/apache/spark/commit/43672dbccbb08df076db861663e71b0e382277c0).

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] gatorsmile commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
gatorsmile commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608536889
 
 
   cc @maryannxue 

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608576490
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder-K8s/25484/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] huaxingao commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
huaxingao commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608586023
 
 
   @srowen Could you take a look of this one too? Thank you!

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608536637
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608582332
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/120785/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608582323
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608536648
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder-K8s/25482/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608600496
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder-K8s/25487/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608605583
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/120788/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608600487
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] maryannxue commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
maryannxue commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608538482
 
 
   It would be worth mentioning the conflict resolving policy in case multiple hints are specified in a query. Even in case a hint can be matched against two different relations with same table name under different namespaces.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608576473
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] SparkQA removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
SparkQA removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608576003
 
 
   **[Test build #120785 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/120785/testReport)** for PR 28113 at commit [`1ae78d8`](https://github.com/apache/spark/commit/1ae78d85f7e902314a9be6e01696d7fe6abcb7f1).

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608536637
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608576490
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder-K8s/25484/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] SparkQA removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
SparkQA removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608535843
 
 
   **[Test build #120783 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/120783/testReport)** for PR 28113 at commit [`0d2e92e`](https://github.com/apache/spark/commit/0d2e92eee6d8cd0b580755183cde50bdbbb0219f).

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608543087
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/120783/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608576473
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] huaxingao commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
huaxingao commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-609868295
 
 
   Thanks all!

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] srowen commented on a change in pull request #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
srowen commented on a change in pull request #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#discussion_r403218675
 
 

 ##########
 File path: docs/sql-ref-syntax-qry-select-hints.md
 ##########
 @@ -1,22 +1,83 @@
 ---
 layout: global
-title: Query Hints
-displayTitle: Query Hints
+title: Join Hints
+displayTitle: Join Hints
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at
- 
+
      http://www.apache.org/licenses/LICENSE-2.0
- 
+
   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
 ---
+### Description
+
+Join Hints allow users to suggest the join strategy that Spark should use. Prior to Spark 3.0, only `BROADCAST` Join Hint was supported. `MERGE`, `SHUFFLE_HASH` and `SHUFFLE_REPLICATE_NL` Joint Hints support was added in 3.0. When different join strategy hints are specified on both sides of a join, Spark prioritizes hints in the following order: `BROADCAST` over `MERGE` over `SHUFFLE_HASH` over `SHUFFLE_REPLICATE_NL`. When both sides are specified with the `BROADCAST` hint or the `SHUFFLE_HASH` hint, Spark will pick the build side based on the join type and the sizes of the relations. Since a given strategy may not support all join types, Spark is not guaranteed to use the join strategy suggested by the hint.
 
 Review comment:
   only BROADCAST Join Hint -> only the BROADCAST 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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] SparkQA commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
SparkQA commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608542894
 
 
   **[Test build #120783 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/120783/testReport)** for PR 28113 at commit [`0d2e92e`](https://github.com/apache/spark/commit/0d2e92eee6d8cd0b580755183cde50bdbbb0219f).
    * This patch passes all tests.
    * This patch merges cleanly.
    * This patch adds no public classes.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] SparkQA commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
SparkQA commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608605384
 
 
   **[Test build #120788 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/120788/testReport)** for PR 28113 at commit [`43672db`](https://github.com/apache/spark/commit/43672dbccbb08df076db861663e71b0e382277c0).
    * This patch passes all tests.
    * This patch merges cleanly.
    * This patch adds no public classes.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] SparkQA commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
SparkQA commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608582166
 
 
   **[Test build #120785 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/120785/testReport)** for PR 28113 at commit [`1ae78d8`](https://github.com/apache/spark/commit/1ae78d85f7e902314a9be6e01696d7fe6abcb7f1).
    * This patch passes all tests.
    * This patch merges cleanly.
    * This patch adds no public classes.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608582323
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608543087
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/120783/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608543080
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608605573
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins commented on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608600487
 
 
   Merged build finished. Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608536648
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder-K8s/25482/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
AmplabJenkins removed a comment on issue #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113#issuecomment-608600496
 
 
   Test PASSed.
   Refer to this link for build results (access rights to CI server needed): 
   https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder-K8s/25487/
   Test PASSed.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] [spark] srowen closed pull request #28113: [SPARK-31333][SQL][DOCS] Document Join Hints

Posted by GitBox <gi...@apache.org>.
srowen closed pull request #28113: [SPARK-31333][SQL][DOCS] Document Join Hints
URL: https://github.com/apache/spark/pull/28113
 
 
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org