Github user dilipbiswal commented on the issue: https://github.com/apache/spark/pull/21049 @henryr I might be a bit of a hardliner on this, but I think it's correct to eliminate the {{ORDER BY}} from common table expressions (e.g. MSSQL agrees with me, see this link). DB>> Yeah.. I had seen this. I had checked DB2 behaviour on CTE and it does not seem to remove the sort. ``` db2 => with x as (select * from t1 order by 1) select * from x C1 C2 ----------- ----------- 0 0 1 1 1 1 2 2 2 2 5 record(s) selected. ``` So perhaps the SQL standard does not explicitly clarify this ?
--- --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org