[HIVE-5560] Hive produces incorrect results on multi-distinct query

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.11.0, 0.12.0
• Fix Version/s: 0.13.0
• Component/s: Query Processor
• Assignee: Navis Ryu
• Reporter: Vikram Dixit K
• Created: 16/Oct/13 01:22
• Updated: 27/Oct/13 09:19
• Resolved: 23/Oct/13 15:26

Description

select key, count(distinct key) + count(distinct value) from src tablesample (10 ROWS) group by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
165 1
val_165 1
238 1
val_238 1
255 1
val_255 1
27  1
val_27  1
278 1
val_278 1
311 1
val_311 1
409 1
val_409 1
484 1
val_484 1
86  1
val_86  1
98  1
val_98  1

Issue Links

• relates to: HIVE-5129 Multiple table insert fails on count(distinct)