All the SortOrder are no-op | 6 ms | Passed |
Empty order by clause | 9 ms | Passed |
Partial order-by clauses contain no-op SortOrder | 9 ms | Passed |
Remove no-op alias | 19 ms | Passed |
SPARK-32318: should not remove orderBy in distribute statement | 13 ms | Passed |
different sorts are not simplified if limit is in between | 27 ms | Passed |
do not remove sort if the order is different | 20 ms | Passed |
filters don't affect order | 15 ms | Passed |
limits don't affect order | 14 ms | Passed |
range is already sorted | 28 ms | Passed |
remove orderBy in groupBy clause with count aggs | 14 ms | Passed |
remove orderBy in groupBy clause with sum aggs | 24 ms | Passed |
remove orderBy in join clause | 17 ms | Passed |
remove orderBy in right join clause event if there is an outer limit | 14 ms | Passed |
remove redundant order by | 29 ms | Passed |
remove sorts separated by Filter/Project operators | 47 ms | Passed |
remove two consecutive sorts | 6 ms | Passed |
should not remove orderBy in groupBy clause with PythonUDF as aggs | 16 ms | Passed |
should not remove orderBy in groupBy clause with ScalaUDF as aggs | 66 ms | Passed |
should not remove orderBy in groupBy clause with first aggs | 16 ms | Passed |
should not remove orderBy in groupBy clause with first and count aggs | 16 ms | Passed |
should not remove orderBy in left join clause if there is an outer limit | 15 ms | Passed |
should not remove orderBy with limit in groupBy clause | 16 ms | Passed |
should not remove orderBy with limit in join clause | 12 ms | Passed |
sort should not be removed when there is a node which doesn't guarantee any order | 58 ms | Passed |