From common-commits-return-11217-apmail-hadoop-common-commits-archive=hadoop.apache.org@hadoop.apache.org Fri Jun 11 01:05:13 2010 Return-Path: Delivered-To: apmail-hadoop-common-commits-archive@www.apache.org Received: (qmail 82800 invoked from network); 11 Jun 2010 01:05:13 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 11 Jun 2010 01:05:13 -0000 Received: (qmail 25490 invoked by uid 500); 11 Jun 2010 01:05:13 -0000 Delivered-To: apmail-hadoop-common-commits-archive@hadoop.apache.org Received: (qmail 25465 invoked by uid 500); 11 Jun 2010 01:05:13 -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 25458 invoked by uid 500); 11 Jun 2010 01:05:13 -0000 Delivered-To: apmail-hadoop-core-commits@hadoop.apache.org Received: (qmail 25455 invoked by uid 99); 11 Jun 2010 01:05:13 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Jun 2010 01:05:13 +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.130] (HELO eos.apache.org) (140.211.11.130) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Jun 2010 01:05:11 +0000 Received: from eos.apache.org (localhost [127.0.0.1]) by eos.apache.org (Postfix) with ESMTP id 22F7616E2D; Fri, 11 Jun 2010 01:04:50 +0000 (GMT) MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable From: Apache Wiki To: Apache Wiki Date: Fri, 11 Jun 2010 01:04:49 -0000 Message-ID: <20100611010449.2827.86243@eos.apache.org> Subject: =?utf-8?q?=5BHadoop_Wiki=5D_Update_of_=22Hive/LanguageManual/DDL=22_by_Ca?= =?utf-8?q?rlSteinbach?= 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 CarlSteinbach. http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=3Ddiff&rev1=3D= 63&rev2=3D64 -------------------------------------------------- = row_format : DELIMITED [FIELDS TERMINATED BY char] [COLLECTION ITEMS TERMINATED BY= char] - [MAP KEYS TERMINATED BY char] + [MAP KEYS TERMINATED BY char] [LINES TERMINATED BY char] | SERDE serde_name [WITH SERDEPROPERTIES (property_name=3Dproperty_valu= e, property_name=3Dproperty_value, ...)] = file_format: @@ -66, +66 @@ = You can create tables with custom SerDe or using native SerDe. A native S= erDe is used if ROW FORMAT is not specified or ROW FORMAT DELIMITED is spec= ified. You can use the DELIMITED clause to read delimited files. Use the SE= RDE clause to create a table with custom SerDe. Refer to SerDe section of t= he User Guide for more information on SerDe. = - You must specify list of a columns for tables with native SerDe. Refer to= the Types part of the User Guide for the allowable column types. A list of= columns for tables with custom SerDe may be specified but Hive will query = the SerDe to determine the actual list of columns for this table. + You must specify a list of a columns for tables that use a native SerDe. = Refer to the Types part of the User Guide for the allowable column types. A= list of columns for tables that use a custom SerDe may be specified but Hi= ve will query the SerDe to determine the actual list of columns for this ta= ble. = Use STORED AS TEXTFILE if the data needs to be stored as plain text files= . Use STORED AS SEQUENCEFILE if the data needs to be compressed. Please rea= d more about [[Hive/CompressedStorage]] if you are planning to keep data co= mpressed in your Hive tables. Use INPUTFORMAT and OUTPUTFORMAT to specify = the name of a corresponding InputFormat and OutputFormat class as a string = literal, e.g. 'org.apache.hadoop.hive.contrib.fileformat.base64.Base64TextI= nputFormat'. =20