Return-Path: Delivered-To: apmail-hadoop-hive-user-archive@minotaur.apache.org Received: (qmail 23746 invoked from network); 12 Jun 2010 06:24:22 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 12 Jun 2010 06:24:22 -0000 Received: (qmail 66802 invoked by uid 500); 12 Jun 2010 06:24:22 -0000 Delivered-To: apmail-hadoop-hive-user-archive@hadoop.apache.org Received: (qmail 66446 invoked by uid 500); 12 Jun 2010 06:24:19 -0000 Mailing-List: contact hive-user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-user@hadoop.apache.org Delivered-To: mailing list hive-user@hadoop.apache.org Received: (qmail 66426 invoked by uid 99); 12 Jun 2010 06:24:18 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 12 Jun 2010 06:24:18 +0000 X-ASF-Spam-Status: No, hits=0.7 required=10.0 tests=RCVD_IN_DNSWL_NONE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [209.85.212.176] (HELO mail-px0-f176.google.com) (209.85.212.176) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 12 Jun 2010 06:24:11 +0000 Received: by pxi10 with SMTP id 10so1843436pxi.35 for ; Fri, 11 Jun 2010 23:23:49 -0700 (PDT) Received: by 10.140.251.20 with SMTP id y20mr2220852rvh.206.1276323829220; Fri, 11 Jun 2010 23:23:49 -0700 (PDT) Received: from [192.168.42.225] ([38.102.147.105]) by mx.google.com with ESMTPS id q10sm2106472rvp.8.2010.06.11.23.23.47 (version=SSLv3 cipher=RC4-MD5); Fri, 11 Jun 2010 23:23:48 -0700 (PDT) Message-ID: <4C1327F1.8040109@cloudera.com> Date: Fri, 11 Jun 2010 23:23:45 -0700 From: Amr Awadallah User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.9) Gecko/20100317 Lightning/1.0b1 Thunderbird/3.0.4 ThunderBrowse/3.2.8.1 MIME-Version: 1.0 To: hive-user@hadoop.apache.org CC: Zheng Shao Subject: Re: Create Table with Line Terminated other than '\n' References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Zheng, I thought that was fixed per you work here, no? https://issues.apache.org/jira/browse/HIVE-302 Then what did you fix? -- amr On 6/10/2010 10:22 PM, Zheng Shao wrote: > Also, changing "LINES TERMINATED BY" probably won't work, because > hadoop's TextInputFormat does not allow line terminators other than > "\n". > > Zheng > > On Thu, Jun 10, 2010 at 6:31 PM, Carl Steinbach wrote: > >> Hi Shuja, >> The grammar for Hive's CREATE TABLE statement is discussed >> here: http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL#Create_Table >> You need to use the "LINES TERMINATED BY" clause in the CREATE TABLE >> statement in order to specify a line terminator other than "\n". >> Carl >> >> On Thu, Jun 10, 2010 at 5:39 PM, Shuja Rehman wrote: >> >>> Hi >>> I want to create a table in hive which should have row formated line >>> terminated other than '\n'. so i can read xml file as single cell in one row >>> and column of table. >>> kindly let me know how to do this? >>> THanks >>> >>> >>> >>> -- >>> Regards >>> Shuja-ur-Rehman Baig >>> _________________________________ >>> MS CS - School of Science and Engineering >>> Lahore University of Management Sciences (LUMS) >>> Sector U, DHA, Lahore, 54792, Pakistan >>> Cell: +92 3214207445 >>> >> >> > > >