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

1 Answer

0 votes
Jan 10, 2020

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

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