in Big Data | Hadoop by
Q:
When should we use SORT BY instead of ORDER BY?

▼ Show 1 Answer

0 votes
by

We should use SORT BY instead of ORDER BY when we have to sort huge datasets because SORT BY clause sorts the data using multiple reducers whereas ORDER BY sorts all of the data together using a single reducer. Therefore, using ORDER BY against a large number of inputs will take a lot of time to execute. 

Learn More with Madanswer

Related questions

0 votes
asked Apr 1, 2020 in Big Data | Hadoop by AdilsonLima
...