Test Result : EliminateSortsSuite

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

All Tests

Test nameDurationStatus
All the SortOrder are no-op4 msPassed
Empty order by clause7 msPassed
Partial order-by clauses contain no-op SortOrder6 msPassed
Remove no-op alias20 msPassed
different sorts are not simplified if limit is in between27 msPassed
do not remove sort if the order is different18 msPassed
filters don't affect order18 msPassed
limits don't affect order14 msPassed
range is already sorted15 msPassed
remove orderBy in groupBy clause with count aggs13 msPassed
remove orderBy in groupBy clause with sum aggs22 msPassed
remove orderBy in join clause15 msPassed
remove orderBy in right join clause event if there is an outer limit13 msPassed
remove redundant order by19 msPassed
remove sorts separated by Filter/Project operators43 msPassed
remove two consecutive sorts9 msPassed
should not remove orderBy in groupBy clause with PythonUDF as aggs12 msPassed
should not remove orderBy in groupBy clause with ScalaUDF as aggs18 msPassed
should not remove orderBy in groupBy clause with first aggs13 msPassed
should not remove orderBy in groupBy clause with first and count aggs11 msPassed
should not remove orderBy in left join clause if there is an outer limit22 msPassed
should not remove orderBy with limit in groupBy clause19 msPassed
should not remove orderBy with limit in join clause22 msPassed
sort should not be removed when there is a node which doesn't guarantee any order33 msPassed