Test Result : EliminateSortsSuite

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

All Tests

Test nameDurationStatus
All the SortOrder are no-op5 msPassed
Empty order by clause6 msPassed
Partial order-by clauses contain no-op SortOrder7 msPassed
Remove no-op alias15 msPassed
different sorts are not simplified if limit is in between9 msPassed
do not remove sort if the order is different14 msPassed
filters don't affect order8 msPassed
limits don't affect order9 msPassed
range is already sorted13 msPassed
remove orderBy in groupBy clause with count aggs10 msPassed
remove orderBy in groupBy clause with sum aggs16 msPassed
remove orderBy in join clause12 msPassed
remove orderBy in right join clause event if there is an outer limit31 msPassed
remove redundant order by14 msPassed
remove sorts separated by Filter/Project operators42 msPassed
remove two consecutive sorts4 msPassed
should not remove orderBy in groupBy clause with PythonUDF as aggs11 msPassed
should not remove orderBy in groupBy clause with ScalaUDF as aggs16 msPassed
should not remove orderBy in groupBy clause with first aggs12 msPassed
should not remove orderBy in groupBy clause with first and count aggs9 msPassed
should not remove orderBy in left join clause if there is an outer limit15 msPassed
should not remove orderBy with limit in groupBy clause19 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 order22 msPassed