Return-Path: Delivered-To: apmail-hadoop-hive-dev-archive@locus.apache.org Received: (qmail 36534 invoked from network); 13 Jan 2009 23:09:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 Jan 2009 23:09:22 -0000 Received: (qmail 32529 invoked by uid 500); 13 Jan 2009 23:09:22 -0000 Delivered-To: apmail-hadoop-hive-dev-archive@hadoop.apache.org Received: (qmail 32483 invoked by uid 500); 13 Jan 2009 23:09:22 -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 32472 invoked by uid 99); 13 Jan 2009 23:09:22 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Jan 2009 15:09:22 -0800 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; Tue, 13 Jan 2009 23:09:20 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 8D6C0234C48B for ; Tue, 13 Jan 2009 15:08:59 -0800 (PST) Message-ID: <403400796.1231888139578.JavaMail.jira@brutus> Date: Tue, 13 Jan 2009 15:08:59 -0800 (PST) From: "Joydeep Sen Sarma (JIRA)" To: hive-dev@hadoop.apache.org Subject: [jira] Updated: (HIVE-217) Stream closed exception In-Reply-To: <1032562198.1231355204349.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/HIVE-217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joydeep Sen Sarma updated HIVE-217: ----------------------------------- Component/s: (was: Serializers/Deserializers) Query Processor > Stream closed exception > ----------------------- > > Key: HIVE-217 > URL: https://issues.apache.org/jira/browse/HIVE-217 > Project: Hadoop Hive > Issue Type: Bug > Components: Query Processor > Environment: Hive from trunk, hadoop 0.18.2, ~20 machines > Reporter: Johan Oskarsson > Priority: Critical > Fix For: 0.2.0 > > Attachments: HIVE-217.log, HIVE-217.patch > > > When running a query similar to the following: > "insert overwrite table outputtable select a, b, cast(sum(counter) as INT) from tablea join tableb on (tablea.username=tableb.username) join tablec on (tablec.userid = tablea.userid) join tabled on (tablec.id=tabled.id) where insertdate >= 'somedate' and insertdate <= 'someotherdate' group by a, b;" > Where one table is ~40gb or so and the others are a couple of hundred mb. The error happens in the first mapred job that processes the 40gb. > I get the following exception (see attached file for full stack trace): > Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.io.IOException: Stream closed. > at org.apache.hadoop.hive.ql.exec.FileSinkOperator.process(FileSinkOperator.java:162) > It happens in one reduce task and is reproducible, running the same query gives the error. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.