Hive中order by、sort by、distribute by和cluster by

Order By语法

colOrder: ( ASC | DESC )
colNullOrder: (NULLS FIRST | NULLS LAST)           -- (Note: Available in Hive 2.1.0 and later)
orderBy: ORDER BY colName colOrder? colNullOrder? (',' colName colOrder? colNullOrder?)*
query: SELECT expression (',' expression)* FROM src orderBy

对全局数据的排序，只有一个reduce

Sort By语法

The SORT BY syntax is similar to the syntax of ORDER BY in SQL language.