Test Result : EliminateSortsSuite

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

All Tests

Test nameDurationStatus
All the SortOrder are no-op3 msPassed
Empty order by clause6 msPassed
Partial order-by clauses contain no-op SortOrder3 msPassed
Remove no-op alias10 msPassed
different sorts are not simplified if limit is in between6 msPassed
do not remove sort if the order is different9 msPassed
filters don't affect order7 msPassed
limits don't affect order6 msPassed
range is already sorted9 msPassed
remove orderBy in groupBy clause with count aggs5 msPassed
remove orderBy in groupBy clause with sum aggs8 msPassed
remove orderBy in join clause7 msPassed
remove orderBy in right join clause event if there is an outer limit6 msPassed
remove redundant order by12 msPassed
remove sorts separated by Filter/Project operators19 msPassed
remove two consecutive sorts4 msPassed
should not remove orderBy in groupBy clause with PythonUDF as aggs6 msPassed
should not remove orderBy in groupBy clause with ScalaUDF as aggs8 msPassed
should not remove orderBy in groupBy clause with first aggs6 msPassed
should not remove orderBy in groupBy clause with first and count aggs7 msPassed
should not remove orderBy in left join clause if there is an outer limit8 msPassed
should not remove orderBy with limit in groupBy clause6 msPassed
should not remove orderBy with limit in join clause6 msPassed
sort should not be removed when there is a node which doesn't guarantee any order15 msPassed