[HIVE-7780] Query with OVER clause return duplicate results[Spark Branch]

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Component/s: Spark
• Assignee: Chengxiang Li
• Reporter: Chengxiang Li
• Created: 19/Aug/14 07:22
• Updated: 19/Aug/14 08:35
• Resolved: 19/Aug/14 08:35

Description

A simple query with the OVER clause return duplicate results.

hive> select address, count(id) over(partition by address) from test;
Query ID = root_20140819150000_f5506fcc-4950-424b-a134-56fc5b06d6eb
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapreduce.job.reduces=<number>
OK
QD	1
SH	2
SH	2
SZ	2
SZ	2

Issue Links

• Is contained by: HIVE-7779 Support windowing and analytic functions [Spark Branch]
• is part of: HIVE-7292 Hive on Spark