You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-dev@hadoop.apache.org by "Jeff Hammerbacher (JIRA)" <ji...@apache.org> on 2008/10/13 09:32:45 UTC
[jira] Created: (HADOOP-4401) ORDER BY clause is ignored for SELECT
statements
ORDER BY clause is ignored for SELECT statements
------------------------------------------------
Key: HADOOP-4401
URL: https://issues.apache.org/jira/browse/HADOOP-4401
Project: Hadoop Core
Issue Type: Bug
Reporter: Jeff Hammerbacher
The "ORDER BY" clause seems to be ignored (see the truncated output below). I'd really like to use this in conjunction with the forthcoming LIMIT clause to get TOP K functionality.
hive> SELECT t.* FROM t ORDER BY t.numfriends;
3 Whatever Dude 25
4 Sweet Guy 20
1 Jeff Hammerbacher 15
2 Teddy Roosevelt 20
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-4401) ORDER BY clause is ignored for SELECT
statements
Posted by "Jeff Hammerbacher (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-4401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jeff Hammerbacher updated HADOOP-4401:
--------------------------------------
Component/s: contrib/hive
I forgot to mark this as part of contrib/hive, so it didn't make the move to Hive's new JIRA, and I created a duplicate issue: http://issues.apache.org/jira/browse/HIVE-61. This issue can be deleted, I suppose, though it has accumulated some watchers and a voter.
> ORDER BY clause is ignored for SELECT statements
> ------------------------------------------------
>
> Key: HADOOP-4401
> URL: https://issues.apache.org/jira/browse/HADOOP-4401
> Project: Hadoop Core
> Issue Type: Bug
> Components: contrib/hive
> Reporter: Jeff Hammerbacher
>
> The "ORDER BY" clause seems to be ignored (see the truncated output below). I'd really like to use this in conjunction with the forthcoming LIMIT clause to get TOP K functionality.
> hive> SELECT t.* FROM t ORDER BY t.numfriends;
> 3 Whatever Dude 25
> 4 Sweet Guy 20
> 1 Jeff Hammerbacher 15
> 2 Teddy Roosevelt 20
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (HADOOP-4401) ORDER BY clause is ignored for
SELECT statements
Posted by "Chris Douglas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-4401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris Douglas resolved HADOOP-4401.
-----------------------------------
Resolution: Duplicate
> ORDER BY clause is ignored for SELECT statements
> ------------------------------------------------
>
> Key: HADOOP-4401
> URL: https://issues.apache.org/jira/browse/HADOOP-4401
> Project: Hadoop Core
> Issue Type: Bug
> Components: contrib/hive
> Reporter: Jeff Hammerbacher
>
> The "ORDER BY" clause seems to be ignored (see the truncated output below). I'd really like to use this in conjunction with the forthcoming LIMIT clause to get TOP K functionality.
> hive> SELECT t.* FROM t ORDER BY t.numfriends;
> 3 Whatever Dude 25
> 4 Sweet Guy 20
> 1 Jeff Hammerbacher 15
> 2 Teddy Roosevelt 20
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.