Javatpoint Logo
Javatpoint Logo

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.

Sort by

May use multiple reducers for final output.

Only guarantees ordering of rows within a reducer.

May give partially ordered result.

Order by

Uses single reducer to guarantee total order in output.

LIMIT can be used to minimize sort time.

Next TopicHive Join





Youtube For Videos Join Our Youtube Channel: Join Now

Feedback


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA