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