[DRILL-6995] Count() function is not working with columns alias

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 1.15.0
• Assignee: Unassigned
• Reporter: Denys Ordynskiy
• Created: 23/Jan/19 12:13
• Updated: 28/Jan/19 08:13
• Resolved: 28/Jan/19 08:13

Description

The query works correctly if I use column name in the count() function:

select department_id c from cp.`employee.json` group by c having count(department_id) > 1

c
1
2
3
11
5
4
19
14
15
16

But when I set column alias "c" in the count() function, Drill returns an empty result set:

select department_id c from cp.`employee.json` group by c having count(c) > 1

c

Issue Links

• Dependent: CALCITE-2799 Allow alias in having clause for aggregate functions