[HIVE-2885] select distinct <string> from table returns wrong result

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 0.8.1
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Mauro Cazzari
• Created: 20/Mar/12 18:17
• Updated: 26/May/12 01:41
• Resolved: 26/May/12 01:41

Description

Give the following table:

CREATE TABLE `MYTAB` (`a` DOUBLE)....

containing the values 1, 2, 3, and 4, the following SQL fails to produce the correct result:

select distinct 'FOO' from `MYTAB`

Note that this issue didn't show up with Hive 7. Only 8.1 seems to be affected.