Test Result : EliminateSortsSuite

0 failures (±0)
24 tests (±0)
Took 1.1 sec.

All Tests

Test nameDurationStatus
All the SortOrder are no-op10 msPassed
Empty order by clause0.25 secPassed
Partial order-by clauses contain no-op SortOrder33 msPassed
Remove no-op alias72 msPassed
different sorts are not simplified if limit is in between31 msPassed
do not remove sort if the order is different0.1 secPassed
filters don't affect order44 msPassed
limits don't affect order20 msPassed
range is already sorted55 msPassed
remove orderBy in groupBy clause with count aggs19 msPassed
remove orderBy in groupBy clause with sum aggs36 msPassed
remove orderBy in join clause25 msPassed
remove orderBy in right join clause event if there is an outer limit34 msPassed
remove redundant order by52 msPassed
remove sorts separated by Filter/Project operators86 msPassed
remove two consecutive sorts12 msPassed
should not remove orderBy in groupBy clause with PythonUDF as aggs20 msPassed
should not remove orderBy in groupBy clause with ScalaUDF as aggs34 msPassed
should not remove orderBy in groupBy clause with first aggs25 msPassed
should not remove orderBy in groupBy clause with first and count aggs23 msPassed
should not remove orderBy in left join clause if there is an outer limit28 msPassed
should not remove orderBy with limit in groupBy clause20 msPassed
should not remove orderBy with limit in join clause39 msPassed
sort should not be removed when there is a node which doesn't guarantee any order0.1 secPassed