Return-Path: X-Original-To: apmail-hadoop-common-commits-archive@www.apache.org Delivered-To: apmail-hadoop-common-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1E2E03C4B for ; Mon, 2 May 2011 22:14:20 +0000 (UTC) Received: (qmail 83746 invoked by uid 500); 2 May 2011 22:14:19 -0000 Delivered-To: apmail-hadoop-common-commits-archive@hadoop.apache.org Received: (qmail 83718 invoked by uid 500); 2 May 2011 22:14:19 -0000 Mailing-List: contact common-commits-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: common-dev@hadoop.apache.org Delivered-To: mailing list common-commits@hadoop.apache.org Received: (qmail 83711 invoked by uid 500); 2 May 2011 22:14:19 -0000 Delivered-To: apmail-hadoop-core-commits@hadoop.apache.org Received: (qmail 83708 invoked by uid 99); 2 May 2011 22:14:19 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 May 2011 22:14:19 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.131] (HELO eos.apache.org) (140.211.11.131) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 May 2011 22:14:17 +0000 Received: from eos.apache.org (localhost [127.0.0.1]) by eos.apache.org (Postfix) with ESMTP id 1C7E78E8; Mon, 2 May 2011 22:13:57 +0000 (UTC) MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable From: Apache Wiki To: Apache Wiki Date: Mon, 02 May 2011 22:13:56 -0000 Message-ID: <20110502221356.82816.64680@eos.apache.org> Subject: =?utf-8?q?=5BHadoop_Wiki=5D_Update_of_=22Hive/LanguageManual/DDL=22_by_Ph?= =?utf-8?q?iloVivero?= X-Virus-Checked: Checked by ClamAV on apache.org Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for ch= ange notification. The "Hive/LanguageManual/DDL" page has been changed by PhiloVivero. The comment on this change is: When I try to create partitions as files... = FAIL.. http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=3Ddiff&rev1=3D= 86&rev2=3D87 -------------------------------------------------- partition_spec: : PARTITION (partition_col =3D partition_col_value, partition_col =3D p= artiton_col_value, ...) }}} - You can use ALTER TABLE ADD PARTITION to add partitions to a table. Part= ition values should be quoted only if they are strings. + You can use ALTER TABLE ADD PARTITION to add partitions to a table. Part= ition values should be quoted only if they are strings. The location must b= e a directory inside of which data files reside. = {{{ ALTER TABLE page_view ADD PARTITION (dt=3D'2008-08-08', country=3D'us') l= ocation '/path/to/us/part080808' PARTITION (dt=3D'2008-08-09', country=3D'u= s') location '/path/to/us/part080809';