[DRILL-5665] planner.force_2phase.aggr Set to TRUE for HashAgg may cause wrong results for VARIANCE and STD_DEV

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.11.0
• Fix Version/s: 1.11.0
• Component/s: Execution - Relational Operators
• Labels: ready-to-commit
• Assignee: Boaz Ben-Zvi
• Reporter: Boaz Ben-Zvi
• Reviewer: Aman Sinha
• Created: 08/Jul/17 02:14
• Updated: 21/Jul/17 17:34
• Resolved: 21/Jul/17 17:34

Description

planner.force_2phase.aggr was added for testing the hash 2-phase spill to disk aggregation implementation. However, if it is set to true, stream aggregate will run in two phase too and return wrong results for some functions such as variance() and std_dev().

Issue Links

• links to: GitHub Pull Request #872