cloud-fan commented on a change in pull request #32932:
URL: https://github.com/apache/spark/pull/32932#discussion_r656246044



##########
File path: docs/sql-performance-tuning.md
##########
@@ -228,6 +228,8 @@ The "REPARTITION_BY_RANGE" hint must have column names and 
a partition number is
     SELECT /*+ REPARTITION */ * FROM t
     SELECT /*+ REPARTITION_BY_RANGE(c) */ * FROM t
     SELECT /*+ REPARTITION_BY_RANGE(3, c) */ * FROM t
+    SELECT /*+ ADAPTIVE_REPARTITION */ * FROM t
+    SELECT /*+ ADAPTIVE_REPARTITION(c) */ * FROM t

Review comment:
       I'm not good at naming, let's get more opinions. cc @dongjoon-hyun 
@HyukjinKwon @maropu @viirya 
   
   Basically this hint means the user wants to add a shuffle right before data 
writing, to redistribute data and avoid small files/skewed partitions. It's 
different from normal repartition as this allows more aggressive optimization 
from AQE.




-- 
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]

Reply via email to