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

        

Reply via email to