in Big Data | Hadoop by
What is the difference between SORT BY and ORDER BY in Hive?

1 Answer

0 votes
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.

Related questions

0 votes
asked Apr 1, 2020 in Big Data | Hadoop by AdilsonLima
0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986