Return-Path: Delivered-To: apmail-hadoop-hive-dev-archive@minotaur.apache.org Received: (qmail 19408 invoked from network); 19 Apr 2009 10:38:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 19 Apr 2009 10:38:10 -0000 Received: (qmail 64579 invoked by uid 500); 19 Apr 2009 10:38:10 -0000 Delivered-To: apmail-hadoop-hive-dev-archive@hadoop.apache.org Received: (qmail 64518 invoked by uid 500); 19 Apr 2009 10:38:10 -0000 Mailing-List: contact hive-dev-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hadoop.apache.org Delivered-To: mailing list hive-dev@hadoop.apache.org Received: (qmail 64508 invoked by uid 99); 19 Apr 2009 10:38:10 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 19 Apr 2009 10:38:10 +0000 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; Sun, 19 Apr 2009 10:38:08 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 70ECC234C004 for ; Sun, 19 Apr 2009 03:37:47 -0700 (PDT) Message-ID: <1648706796.1240137467447.JavaMail.jira@brutus> Date: Sun, 19 Apr 2009 03:37:47 -0700 (PDT) From: "Zheng Shao (JIRA)" To: hive-dev@hadoop.apache.org Subject: [jira] Commented: (HIVE-432) SORT BY is always sending data to only the first reducer even if there are multiple reducers In-Reply-To: <389705722.1240133027450.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/HIVE-432?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12700575#action_12700575 ] Zheng Shao commented on HIVE-432: --------------------------------- A test on our cluster showed the patch fixed the problem. > SORT BY is always sending data to only the first reducer even if there are multiple reducers > -------------------------------------------------------------------------------------------- > > Key: HIVE-432 > URL: https://issues.apache.org/jira/browse/HIVE-432 > Project: Hadoop Hive > Issue Type: Bug > Components: Query Processor > Reporter: Zheng Shao > Assignee: Zheng Shao > Priority: Critical > Attachments: HIVE-432.1.patch > > > When we generate the ReduceSInkOperator, the partition columns are empty, which means all the rows will get a hash value of 0, and they will all go to the first reducer. > In the meanwhile we are fixing this bug, please use "CLUSTER BY" instead of "SORT BY" so that the data will get distributed to multiple reducers. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.