Test Result : EliminateSortsSuite

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

All Tests

Test nameDurationStatus
All the SortOrder are no-op13 msPassed
Empty order by clause7 msPassed
Partial order-by clauses contain no-op SortOrder7 msPassed
Remove no-op alias16 msPassed
different sorts are not simplified if limit is in between13 msPassed
do not remove sort if the order is different12 msPassed
filters don't affect order11 msPassed
limits don't affect order17 msPassed
range is already sorted41 msPassed
remove orderBy in groupBy clause with count aggs6 msPassed
remove orderBy in groupBy clause with sum aggs10 msPassed
remove orderBy in join clause9 msPassed
remove orderBy in right join clause event if there is an outer limit8 msPassed
remove redundant order by19 msPassed
remove sorts separated by Filter/Project operators40 msPassed
remove two consecutive sorts0.14 secPassed
should not remove orderBy in groupBy clause with PythonUDF as aggs9 msPassed
should not remove orderBy in groupBy clause with ScalaUDF as aggs13 msPassed
should not remove orderBy in groupBy clause with first aggs9 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 limit0.76 secPassed
should not remove orderBy with limit in groupBy clause9 msPassed
should not remove orderBy with limit in join clause10 msPassed
sort should not be removed when there is a node which doesn't guarantee any order31 msPassed