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: [email protected]
For additional commands, e-mail: [email protected]
