You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Mauro Cazzari (Created) (JIRA)" <ji...@apache.org> on 2012/03/20 19:17:39 UTC
[jira] [Created] (HIVE-2885) select distinct from table
returns wrong result
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
[jira] [Commented] (HIVE-2885) select distinct from table
returns wrong result
Posted by "Mauro Cazzari (Commented) (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Resolved] (HIVE-2885) select distinct from table
returns wrong result
Posted by "Edward Capriolo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2885?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Capriolo resolved HIVE-2885.
-----------------------------------
Resolution: Cannot Reproduce
> 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