Sort By in SQL Command Hive

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

Sort By

Sort By clause sorts the input (according to whichever column name feed). In this, sorting will be done, before its being feed to the reducer.

select * from person sort by age desc;
OK
4    Tim    48    52000.0    IT
3    Royen    45    85000.0    PR
2    Harry    30    42000.0    HR
5    Rony    28    35000.0    HR
1    John    23    15000.0    IT

...