Return-Path: Delivered-To: apmail-hive-user-archive@www.apache.org Received: (qmail 45855 invoked from network); 7 Jan 2011 08:50:49 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 7 Jan 2011 08:50:49 -0000 Received: (qmail 16658 invoked by uid 500); 7 Jan 2011 08:50:49 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 16465 invoked by uid 500); 7 Jan 2011 08:50:48 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 16452 invoked by uid 500); 7 Jan 2011 08:50:48 -0000 Delivered-To: apmail-hadoop-hive-user@hadoop.apache.org Received: (qmail 16449 invoked by uid 99); 7 Jan 2011 08:50:48 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Jan 2011 08:50:48 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=10.0 tests=FREEMAIL_FROM,HK_RANDOM_ENVFROM,RCVD_IN_DNSWL_LOW,RFC_ABUSE_POST,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of zjffdu@gmail.com designates 209.85.161.48 as permitted sender) Received: from [209.85.161.48] (HELO mail-fx0-f48.google.com) (209.85.161.48) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Jan 2011 08:50:40 +0000 Received: by fxm2 with SMTP id 2so16565914fxm.35 for ; Fri, 07 Jan 2011 00:50:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:date:message-id :subject:from:to:content-type; bh=BNFZvS4gnf64tNuUmhqV5YgqLm3nxtFR+DwE3NjhNlQ=; b=MxIFiE+ma1ADl6uxf74KQrpEeLH+mJQG9qCTJ54mHeldchTT3KfJLjYiJMPkkLyWIS LDgk06B2OhcmM39Y2Sy+rysgdG9cXjL6aoxv+g4v52aBX2v8pmv5aioZlgXXiUKbHVIb zJRxhohqkD6ZM/Jt+O7f3QBw5OvEGNuQTXHRk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=pN0Gg0qLMdZlCEpuEV6pHO197ePUQhK20oE081P8OAq61LKl+zhT7Ya2yRHnCLoF23 Ql2STFJ5AogzusIB6PWbjlWVXHetFGxSUv4EYMeqmuJul5cXstrVzy2xCyN1T9Qufe29 EpoPHafWhqYttzJsHdXLIYXHmpdzJRTAWaISQ= MIME-Version: 1.0 Received: by 10.223.74.142 with SMTP id u14mr2301205faj.97.1294390220525; Fri, 07 Jan 2011 00:50:20 -0800 (PST) Received: by 10.223.119.147 with HTTP; Fri, 7 Jan 2011 00:50:20 -0800 (PST) Date: Fri, 7 Jan 2011 16:50:20 +0800 Message-ID: Subject: Find a case that does not make sense in hive From: Jeff Zhang To: hive-user@hadoop.apache.org Content-Type: text/plain; charset=UTF-8 X-Virus-Checked: Checked by ClamAV on apache.org Hi all I create a table with a partition. Then I import data into this table without specify partition, in this case I cannot retrieval data from this table using select statement. But I can retrieve data when importing data with specify partition. So I think since hive do not allow me to retrieve data in the first case, it should not allow me to import data without specify partition -- Best Regards Jeff Zhang