Live instructor-led & Self-paced Online Certification Training Courses (Big Data, Hadoop, Spark) › Forums › Hadoop › Difference between order by and sort by in Hive? This topic contains 1 reply, has 1 voice, and was last updated by dfbdteam3 4 months ago. Viewing 2 posts - 1 through 2 (of 2 total) Author Posts September 20, 2018 at 12:50 pm #4944 dfbdteam3Moderator What is the difference between order by and sort by in Hive? Comparison between order by and sort by in Hive? September 20, 2018 at 12:50 pm #4945 dfbdteam3Moderator Basically, to fetch data in sorted order Hive sort by and order by commands are used in Apache Hive. But there are few differences such as: Order By Query Syntax SELECT [ALL | DISTINCT] select_expr, select_expr, … FROM table_reference [WHERE where_condition] [GROUP BY col_list] [HAVING having_condition] [ORDER BY col_list]] [LIMIT number]; – In order to guarantee the total order in output, it uses a single reducer. – And, to minimize sort time, we can use the LIMIT. To learn Order by in detail, follow the link: HiveQL Select – Order By Query Sort by Query – While it comes to final output, it may use multiple reducers. – It only guarantees to order of rows within a reducer. – It may offer a partially ordered result. similarly, learn about Hive Sort by Query in detail: Hive Sort by Author Posts Viewing 2 posts - 1 through 2 (of 2 total) You must be logged in to reply to this topic.