[HIVE-7527] Support order by and sort by on Spark [Spark Branch]

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: Spark
• Assignee: Rui Li
• Reporter: Xuefu Zhang
• Created: 27/Jul/14 22:32
• Updated: 29/May/15 02:32
• Resolved: 05/Aug/14 05:39

Description

Currently Hive depends completely on MapReduce's sorting as part of shuffling to achieve order by (global sort, one reducer) and sort by (local sort).
Spark has a sort by transformation in different variations that can used to support Hive's order by and sort by. However, we still need to evaluate weather Spark's sortBy can achieve the same functionality inherited from MapReduce's shuffle sort.

Currently Hive on Spark should be able to run simple sort by or order by, by changing the currently partitionBy to sortby. This is the way to verify theories. Complete solution will not be available until we have complete SparkPlanGenerator.

There is also a question of how we determine that there is order by or sort by by just looking at the operator tree, from which Spark task is created. This is the responsibility of SparkPlanGenerator, but we need to have an idea.

Issue Links

• relates to: HIVE-7772 Add tests for order/sort/distribute/cluster by query [Spark Branch]
• links to: Review Board