[ https://issues.apache.org/jira/browse/HIVE-2885?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13233663#comment-13233663 ]
Mauro Cazzari commented on HIVE-2885: ------------------------------------- I just verified that the problem seems to have gone away with the latest version of Hive. If anyone knows which Hive issue fixed this, feel free to mark it as a DUP. Thanks! > select distinct <string> from table returns wrong result > -------------------------------------------------------- > > Key: HIVE-2885 > URL: https://issues.apache.org/jira/browse/HIVE-2885 > Project: Hive > Issue Type: Bug > Components: SQL > Affects Versions: 0.8.1 > Reporter: Mauro Cazzari > > 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. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira