Categories

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

1 Answer

Jan 10

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. 

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

Madanswer
Apr 1 in Big Data | Hadoop
Oct 17 in Git
Apr 3 in Big Data | Hadoop
...