wangyum commented on pull request #33702:
URL: https://github.com/apache/spark/pull/33702#issuecomment-899929979


   > can we create a list of duplicate safe aggregations, and only allow it for 
them? e.g.) min max
   
   +1. This is a real case of our cluster. The view1 is a left outer join:
   ```sql
   SELECT COALESCE((SELECT MAX(CK_DATE) FROM view1 WHERE 1=1), 
CAST('2018-01-01' AS DATE));
   ```
   Without this optimization | With this optimization
   -- | --
   
![image](https://user-images.githubusercontent.com/5399861/129649316-4de1d930-e513-4104-b83d-7a1d087c5076.png)
 | 
![image](https://user-images.githubusercontent.com/5399861/129650354-a01a7208-f096-419b-93ee-69a910106eaa.png)
   
   
   
   


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