wangyum commented on PR #40462:
URL: https://github.com/apache/spark/pull/40462#issuecomment-1487867844

   It is meaningless to only optimize this case, because the user can manually 
remove the hint:
   ```sql
   SELECT /*+ REBALANCE */ * FROM tbl LIMIT 5;
   ```
   
   I'd like to optimize this case, since the user cannot manually remove the 
hint, because the view may be maintained by others:
   ```sql
   CREATE VIEW full_query_log
   AS
   SELECT h.* FROM query_log_hdfs h
   UNION ALL
   SELECT /*+ REBALANCE */ q.*, DATE(start) FROM query_log_mysql q;
   
   SELECT * FROM full_query_log limit 5;
   ```


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

Reply via email to