Return-Path: Delivered-To: apmail-hadoop-core-dev-archive@www.apache.org Received: (qmail 65401 invoked from network); 13 Oct 2008 07:33:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 Oct 2008 07:33:12 -0000 Received: (qmail 90087 invoked by uid 500); 13 Oct 2008 07:33:06 -0000 Delivered-To: apmail-hadoop-core-dev-archive@hadoop.apache.org Received: (qmail 90076 invoked by uid 500); 13 Oct 2008 07:33:06 -0000 Mailing-List: contact core-dev-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: core-dev@hadoop.apache.org Delivered-To: mailing list core-dev@hadoop.apache.org Received: (qmail 90060 invoked by uid 99); 13 Oct 2008 07:33:06 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Oct 2008 00:33:06 -0700 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Oct 2008 07:32:08 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 87413234C21C for ; Mon, 13 Oct 2008 00:32:45 -0700 (PDT) Message-ID: <316445901.1223883165553.JavaMail.jira@brutus> Date: Mon, 13 Oct 2008 00:32:45 -0700 (PDT) From: "Jeff Hammerbacher (JIRA)" To: core-dev@hadoop.apache.org Subject: [jira] Created: (HADOOP-4401) ORDER BY clause is ignored for SELECT statements MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org 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.