[HIVE-5658] count(distinct) produces confusing results for null

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Assignee: Unassigned
• Reporter: Sergey Shelukhin
• Created: 26/Oct/13 01:35
• Updated: 28/Oct/13 16:43
• Resolved: 28/Oct/13 16:43

Description

select csmallint, count(distinct(csmallint)) from alltypesorc group by csmallint limit 3;

produces:

NULL	0
-16379	1
-16373	1

There are records in table with NULL values; however the count in this case should be 1, not 0, it seems. This is with TopN disabled, so it is unrelated to the other bug