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 2012/07/18 11:44:33 UTC
[jira] [Created] (HIVE-3269) selectlist needs to be superset of the
cluster list
Namit Jain created HIVE-3269:
--------------------------------
Summary: selectlist needs to be superset of the cluster list
Key: HIVE-3269
URL: https://issues.apache.org/jira/browse/HIVE-3269
Project: Hive
Issue Type: Bug
Reporter: Namit Jain
The query:
create table T (key1 string, key2 string, key3 string);
select key1, key2 from T cluster by key1, key2, key3;
fails.
--
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-3269) selectlist needs to be superset of
the cluster list
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13416978#comment-13416978 ]
Namit Jain commented on HIVE-3269:
----------------------------------
Wont it be good to take a similar approach like groupby ?
I mean, have a dummy select first, and then cluster by/order by can resolve.
> selectlist needs to be superset of the cluster list
> ---------------------------------------------------
>
> Key: HIVE-3269
> URL: https://issues.apache.org/jira/browse/HIVE-3269
> Project: Hive
> Issue Type: Bug
> Reporter: Namit Jain
>
> The query:
> create table T (key1 string, key2 string, key3 string);
> select key1, key2 from T cluster by key1, key2, key3;
> fails.
--
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-3269) selectlist needs to be superset of
the cluster list
Posted by "Navis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13416979#comment-13416979 ]
Navis commented on HIVE-3269:
-----------------------------
Yes, adding dummy column was not hard. But alias problem was quite difficult.
> selectlist needs to be superset of the cluster list
> ---------------------------------------------------
>
> Key: HIVE-3269
> URL: https://issues.apache.org/jira/browse/HIVE-3269
> Project: Hive
> Issue Type: Bug
> Reporter: Namit Jain
>
> The query:
> create table T (key1 string, key2 string, key3 string);
> select key1, key2 from T cluster by key1, key2, key3;
> fails.
--
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] [Comment Edited] (HIVE-3269) selectlist needs to be superset
of the cluster list
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13416978#comment-13416978 ]
Namit Jain edited comment on HIVE-3269 at 7/18/12 10:27 AM:
------------------------------------------------------------
Wont it be good to take a similar approach like groupby ?
I mean, have a dummy select first, and then cluster by/order by can resolve.
But then, it would be difficult to support column aliases.
was (Author: namit):
Wont it be good to take a similar approach like groupby ?
I mean, have a dummy select first, and then cluster by/order by can resolve.
> selectlist needs to be superset of the cluster list
> ---------------------------------------------------
>
> Key: HIVE-3269
> URL: https://issues.apache.org/jira/browse/HIVE-3269
> Project: Hive
> Issue Type: Bug
> Reporter: Namit Jain
>
> The query:
> create table T (key1 string, key2 string, key3 string);
> select key1, key2 from T cluster by key1, key2, key3;
> fails.
--
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