Categories

Jan 12 in Big Data | Hadoop

Q: What is the difference between SORT BY and ORDER BY in Hive?

1 Answer

Jan 12
In Hive we use, SORT BY to sort data in each Reducer. We can use multiple Reducers in SORT BY clause.

We can use ORDER BY to sort all the data that passes through one Reducer. So ORDER BY option

 

can be use only with one Reducer.

ORDER BY guarantees total order in the output. SORT BY guarantees ordering only within the data of one reducer.
Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

Madanswer
Apr 1 in Big Data | Hadoop
Jan 12 in Big Data | Hadoop
Nov 28, 2019 in Machine Learning
...