Hive Sort By vs Order By
Hive sort by and order by commands are used to fetch data in sorted order. The main differences between sort by and order by commands are given below.
May use multiple reducers for final output.
Only guarantees ordering of rows within a reducer.
May give partially ordered result.
Uses single reducer to guarantee total order in output.
LIMIT can be used to minimize sort time.