[DRILL-850] support of multiple count(distinct) inconsistent

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Execution - Relational Operators
• Assignee: Aman Sinha
• Reporter: Zhiyong Liu
• Created: 28/May/14 21:15
• Updated: 07/Jan/15 23:25
• Resolved: 07/Jan/15 23:25

Description

git.commit.id.abbrev=01bf849
git.commit.id=01bf8496b217781521c943cc1a9a38ed9f841288

With planner.enable_multiphase_agg and planner.enable_hashagg set to false, planner.enable_hashagg is encountered for the following query:

select cast(c_groupby as varchar(4)), count(distinct(c_int)), count(distinct(c_bigint)), count(distinct(c_float4)), count(distinct(c_float8)) from data group by c_groupby;