hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bill Graham (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-647) ORDER BY with GROUP ignored without LIMIT
Date Thu, 16 Jul 2009 20:57:16 GMT
ORDER BY with GROUP ignored without LIMIT
-----------------------------------------

                 Key: HIVE-647
                 URL: https://issues.apache.org/jira/browse/HIVE-647
             Project: Hadoop Hive
          Issue Type: Bug
          Components: Query Processor
            Reporter: Bill Graham


For queries with GROUP BY and SORT BY, the sort is not handled properly when a LIMIT is not
supplied. If I run the following two queries, the first returns properly sorted results. The
second does not.

SELECT user, SUM(numRequests) AS num FROM MyTable GROUP BY user SORT BY num DESC LIMIT 50;
SELECT user, SUM(numRequests) AS num FROM MyTable GROUP BY user SORT BY num DESC;

Explain is different for the two queries as well. The first uses 3 M/R jobs and the second
only uses 2, which might be part of the problem.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message