Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id ECA52102F5 for ; Fri, 20 Sep 2013 19:07:59 +0000 (UTC) Received: (qmail 34813 invoked by uid 500); 20 Sep 2013 19:07:56 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 34605 invoked by uid 500); 20 Sep 2013 19:07:50 -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 34560 invoked by uid 99); 20 Sep 2013 19:07:48 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Sep 2013 19:07:48 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [98.138.229.24] (HELO nm31.bullet.mail.ne1.yahoo.com) (98.138.229.24) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Sep 2013 19:07:39 +0000 Received: from [127.0.0.1] by nm31.bullet.mail.ne1.yahoo.com with NNFMP; 20 Sep 2013 19:07:18 -0000 Received: from [98.138.90.57] by nm31.bullet.mail.ne1.yahoo.com with NNFMP; 20 Sep 2013 19:04:25 -0000 Received: from [66.196.81.170] by tm10.bullet.mail.ne1.yahoo.com with NNFMP; 20 Sep 2013 19:04:25 -0000 Received: from [98.139.212.207] by tm16.bullet.mail.bf1.yahoo.com with NNFMP; 20 Sep 2013 19:04:25 -0000 Received: from [127.0.0.1] by omp1016.mail.bf1.yahoo.com with NNFMP; 20 Sep 2013 19:04:25 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 514242.91838.bm@omp1016.mail.bf1.yahoo.com Received: (qmail 47424 invoked by uid 60001); 20 Sep 2013 19:04:25 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1379703865; bh=t2RZS9WaNH6UvQJaKz+nCinN1EkdX29FUzXu7vSPZek=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=v4hKWF72r6iS4M49G8EbK/JY3wvsAMntG2QYPh7h/+goLYY66HbjKDm6rqhgBxoKDfsuKJHMjkmcfe80fc1XBaklVDm4EGDvscOIGSJjraOCRYV+N6YXTxAEPlcPgaNiCSjh20WLzI8TvaW417KeIyKaQqiuX7kj7e0vGSjdp0E= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=Ywr3wp2raE6UdzvBLtnfw1YlwxFNJ+cAoxrY8/+VRjk3p9jZsfFsVoEL6ZGKscKgBt/1yR0mzqvsYW4mBL2YwVrXnlmrVP1K1Q8F0VKoUpikoOOS7dpz00xTUdvgUPp4JJCzTHf/R1V5PESa2Z713A7In+91VNjl+/ZOZNJTP5o=; X-YMail-OSG: eDOwhnUVM1kW0icM58PMagN60QVwfcT.KogaDoIYOmoZCJG mDtfMHGwZAN.qy61UIpKsRhomjKz8MCWaz2zO8fj5.i3b60f6u4rLvE.2O7W x.ks3D0YmUUKDXpRKkwuI.jxkK4sxYhE0vAbjVc4YbsPh3HI4TRFWD9Cdjb7 CrcIus.y5I7fRJLdvNHi1A65Cspkcr0OXx.Fi8jU8dU3kyQCAUV0ZqwvATAc cYwY4wfy4ZIPWs8Fzz3sLBiO.gOcPKORxu9maYz2s2oVTSPw0YlXm6m7M25O 2PNDpKlMIMHElJPFTDMgUpFpA1527KIqTqc_cWTgNMt1zCbpFlpxVhcsSzZj HYPguUF9PyX9GRoFy3RJyqwSdwddIYuG8zcxBYJijpw6FoADH8wQ6Ah_fdYV la_8OyWZsj4itkXJYfNwfu4jVZ_5eSggtn5iwiQQrCA6AHXBscIoCm5z6z90 ztmNIxwLJrk.Yr4_cmJM89v0xu0tp0Bfn8F1LMMNr9VIeb8OKYh17B7CV33m ysuXBzrNRCSVBn8toBJrogFWVnIYQ Received: from [151.124.247.200] by web162201.mail.bf1.yahoo.com via HTTP; Fri, 20 Sep 2013 12:04:25 PDT X-Rocket-MIMEInfo: 002.001,SGksCsKgCkkgaGF2ZSBhIGZpbGUgd2hpY2ggaXMgZGVsaW10ZWQgYnkgYSB0YWIuIEFsc28sIHRoZXJlIGFyZSBzb21lIGZpZWxkcyBpbiB0aGUgZmlsZSB3aGljaCBoYXMgYSB0YWIgL3QgY2hhcmFjdGVyIGFuZCBhIG5ldyBsaW5lIC9uIGNoYXJhY3RlciBpbsKgc29tZSBmaWVsZHMuCsKgCklzIHRoZXJlIGFueSB3YXkgdG8gbG9hZCB0aGlzIGZpbGUgdXNpbmcgSGl2ZSBsb2FkIGNvbW1hbmQ_IE9yIGRvIGkgaGF2ZSB0byB1c2UgYSBDdXN0b20gTWFwIFJlZHVjZSAoY3VzdG9tKSBJbnB1dCBmb3JtYXQgd2kBMAEBAQE- X-Mailer: YahooMailWebService/0.8.157.561 Message-ID: <1379703865.46912.YahooMailNeo@web162201.mail.bf1.yahoo.com> Date: Fri, 20 Sep 2013 12:04:25 -0700 (PDT) From: Raj Hadoop Reply-To: Raj Hadoop Subject: How to load /t /n file to Hive To: Hive MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1252958027-2004573904-1379703865=:46912" X-Virus-Checked: Checked by ClamAV on apache.org ---1252958027-2004573904-1379703865=:46912 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi,=0A=A0=0AI have a file which is delimted by a tab. Also, there are some = fields in the file which has a tab /t character and a new line /n character= in=A0some fields.=0A=A0=0AIs there any way to load this file using Hive lo= ad command? Or do i have to use a Custom Map Reduce (custom) Input format w= ith java ? Please advise.=0A=A0=0AThanks,=0ARaj ---1252958027-2004573904-1379703865=:46912 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi,
 
I have a file which is delimted by a tab. Also, = there are some fields in the file which has a tab /t character and a new li= ne /n character in some fields.
 
Is there any way to load this file using Hive lo= ad command? Or do i have to use a Custom Map Reduce (custom) Input format w= ith java ? Please advise.
 
Thanks,
Raj
---1252958027-2004573904-1379703865=:46912--