Test Result : EliminateSortsSuite

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

All Tests

Test nameDurationStatus
All the SortOrder are no-op2 msPassed
Empty order by clause4 msPassed
Partial order-by clauses contain no-op SortOrder3 msPassed
Remove no-op alias8 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 order6 msPassed
limits don't affect order5 msPassed
range is already sorted7 msPassed
remove orderBy in groupBy clause with count aggs4 msPassed
remove orderBy in groupBy clause with sum aggs8 msPassed
remove orderBy in join clause6 msPassed
remove orderBy in right join clause event if there is an outer limit6 msPassed
remove redundant order by9 msPassed
remove sorts separated by Filter/Project operators17 msPassed
remove two consecutive sorts3 msPassed
should not remove orderBy in groupBy clause with PythonUDF as aggs6 msPassed
should not remove orderBy in groupBy clause with ScalaUDF as aggs12 msPassed
should not remove orderBy in groupBy clause with first aggs6 msPassed
should not remove orderBy in groupBy clause with first and count aggs6 msPassed
should not remove orderBy in left join clause if there is an outer limit7 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 order16 msPassed