You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2009/11/10 01:21:32 UTC
[jira] Created: (HIVE-919) distinct on multiple columns should be
supported
distinct on multiple columns should be supported
------------------------------------------------
Key: HIVE-919
URL: https://issues.apache.org/jira/browse/HIVE-919
Project: Hadoop Hive
Issue Type: New Feature
Reporter: Namit Jain
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-919) distinct on multiple columns should be
supported
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12776144#action_12776144 ]
Zheng Shao commented on HIVE-919:
---------------------------------
Do you mean:
select count(distinct c1, c2, c3) from T;
The workaround is:
select count(1) from (select distinct c1, c2, c3 from T) t;
This also extends to:
select c4, count(distinct c1, c2, c3) from T group by c4;
and
select c4, count(c1, c2, c3) from (select distinct c1, c2, c3, c4 from T) t group by c4;
> distinct on multiple columns should be supported
> ------------------------------------------------
>
> Key: HIVE-919
> URL: https://issues.apache.org/jira/browse/HIVE-919
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Namit Jain
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (HIVE-919) distinct on multiple columns should be
supported
Posted by "Jeff Hammerbacher (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jeff Hammerbacher resolved HIVE-919.
------------------------------------
Resolution: Duplicate
Duplicate of https://issues.apache.org/jira/browse/HIVE-474
> distinct on multiple columns should be supported
> ------------------------------------------------
>
> Key: HIVE-919
> URL: https://issues.apache.org/jira/browse/HIVE-919
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Namit Jain
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (HIVE-919) distinct on multiple columns should be
supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain reopened HIVE-919:
-----------------------------
> distinct on multiple columns should be supported
> ------------------------------------------------
>
> Key: HIVE-919
> URL: https://issues.apache.org/jira/browse/HIVE-919
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Namit Jain
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-919) distinct on multiple columns should be
supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12775205#action_12775205 ]
Namit Jain commented on HIVE-919:
---------------------------------
I meant the following query:
select distinct c1,c2,c3 from T
> distinct on multiple columns should be supported
> ------------------------------------------------
>
> Key: HIVE-919
> URL: https://issues.apache.org/jira/browse/HIVE-919
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Namit Jain
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-919) distinct on multiple columns should be
supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12775206#action_12775206 ]
Namit Jain commented on HIVE-919:
---------------------------------
The work around is to do:
select count(1) from T group by c1,c2,c3;
> distinct on multiple columns should be supported
> ------------------------------------------------
>
> Key: HIVE-919
> URL: https://issues.apache.org/jira/browse/HIVE-919
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Namit Jain
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-919) distinct on multiple columns should be
supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12776158#action_12776158 ]
Namit Jain commented on HIVE-919:
---------------------------------
I agree there are workarounds. But, it would be useful to support the above syntax - that is the one that comes to mind first
> distinct on multiple columns should be supported
> ------------------------------------------------
>
> Key: HIVE-919
> URL: https://issues.apache.org/jira/browse/HIVE-919
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Namit Jain
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.