[IMPALA-4042] count(distinct NULL) fails on a view

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.7.0
• Fix Version/s: Impala 2.8.0
• Component/s: Frontend
• Labels: ramp-up
• Target Version: Impala 2.8.0
• Assignee: Yonghyun Hwang
• Reporter: Matthew Jacobs
• Created: 30/Aug/16 00:10
• Updated: 04/Jan/17 23:58
• Resolved: 05/Oct/16 17:33

Description

[localhost:21000] > create view test_view as SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month, day FROM functional.alltypesagg;
Query: create view test_view as SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col, year, month, day FROM functional.alltypesagg
++
||
++
++
Fetched 0 row(s) in 0.06s
[localhost:21000] > select count(distinct null) from test_view;
Query: select count(distinct null) from test_view
Query submitted at: 2016-08-29 17:07:44 (Coordinator: http://mj-desktop.ca.cloudera.com:25000)
ERROR: IllegalStateException: Grouping expr NULL returns type NULL_TYPE but its output tuple slot has type BOOLEAN