二.排序
1.ORDER BY
示例:
统计order_items表中销售量最多的商品
hive> select order_item_order_id,order_item_product_id,order_item_quantity
> from order_items order by order_item_quantity desc limit 10;
2.SORT BY
示例:
查看商品分类表categories,结果按分类名称category_name升序排列
hive> set mapred.reduce.tasks=2;
hive> select * from categories sort by category_name;
3.DISTRIBUTE BY
示例:
查看商品分类表categories,结果按分类名称category_name升序排列,要求同一大类的商品分类在同一个Reducer中处理
hive> set mapred.reduce.tasks=2;
hive> select * from categories distribute by category_department_id sort by category_name;
4.CLUSTER BY
相当于DISTRIBUTE BY和SORT BY 的结合体