[
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.
