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 AA87D1168E for ; Thu, 31 Jul 2014 19:13:07 +0000 (UTC) Received: (qmail 82866 invoked by uid 500); 31 Jul 2014 19:13:06 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 82807 invoked by uid 500); 31 Jul 2014 19:13:05 -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 82797 invoked by uid 99); 31 Jul 2014 19:13:05 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 31 Jul 2014 19:13:05 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [209.85.219.47] (HELO mail-oa0-f47.google.com) (209.85.219.47) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 31 Jul 2014 19:13:01 +0000 Received: by mail-oa0-f47.google.com with SMTP id g18so2318393oah.20 for ; Thu, 31 Jul 2014 12:12:39 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=tWaX3mmMxA60JqWHrwlfLuyxVhRyCZehwYl32z4EEyQ=; b=VKsz6FZ14HcS2AfNP1z4HN1sw+dVL1O8VkwMpLf1mbHmNb6WXTJWT474EP9KsYTIhc axCROHR06VEkLm1WxDahUxqsimDF+wBbmi00fwNEhSX7fLpqYiu3rutWaY/J4hzKfUYF AVPcmaKug167ZQZGosTkLJeNJvk9p8P2ASmX+/8dhZgVPjwTYyyYeshyFXcp1Ng4JV9T EDz9b6eXY5aSSnLaBkr74mLsM7rT6HYUFmltgRsVdCPvJTAyViUOPbJ1EHLHdt25rPmR CE6/fvrS7BP7r7L3Zkd6zj6JFVIqiBD9xRTurz0DekL/vRvq/iwnL0Z9jXgAlFZ5ofRY x06w== X-Gm-Message-State: ALoCoQnhkGyieEzVQt0MqPu23QfBhYVLnhIv/CTeI2ykxwxhj+hwQat/ri5dwGJyrfJbCULYUSMU MIME-Version: 1.0 X-Received: by 10.182.236.225 with SMTP id ux1mr320048obc.57.1406833959166; Thu, 31 Jul 2014 12:12:39 -0700 (PDT) Received: by 10.76.25.40 with HTTP; Thu, 31 Jul 2014 12:12:39 -0700 (PDT) In-Reply-To: References: Date: Thu, 31 Jul 2014 12:12:39 -0700 Message-ID: Subject: Re: Input From: Bala Krishna Gangisetty To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a11c2fad06507ae04ff820e8f X-Virus-Checked: Checked by ClamAV on apache.org --001a11c2fad06507ae04ff820e8f Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable You might want to write a custom SerDe with a simple logic to convert string to integer. --Bala G. On Thu, Jul 31, 2014 at 3:29 AM, CHEBARO Abdallah < Abdallah.CHEBARO@murex.com> wrote: > I know it will be a complete string. I am trying to =E2=80=9Cinteger=E2= =80=9D without > the quotations. > > > > *From:* Nitin Pawar [mailto:nitinpawar432@gmail.com] > *Sent:* Thursday, July 31, 2014 1:28 PM > *To:* user@hive.apache.org > *Subject:* Re: Input > > > > if you specified ; as your delimiter then "abc" will be complete string > and not abc only. > > > > Take a look at csv fileformat if you want to use proper comma delimited > feature > > > > On Thu, Jul 31, 2014 at 3:44 PM, CHEBARO Abdallah < > Abdallah.CHEBARO@murex.com> wrote: > > Hello, > > > > I am using Hive and trying to read from a txt file. > > > > I have an input like the following: =E2=80=9Cstring=E2=80=9D;=E2=80=9Dstr= ing=E2=80=9D;=E2=80=9Dinteger=E2=80=9D. > > > > First, I specified that the row fields are delimited by a semi-column. Is > it possible to read the integer without the quotations? > > > > Thank you > > ******************************* > > This e-mail contains information for the intended recipient only. It may > contain proprietary material or confidential information. If you are not > the intended recipient you are not authorised to distribute, copy or use > this e-mail or any attachment to it. Murex cannot guarantee that it is > virus free and accepts no responsibility for any loss or damage arising > from its use. If you have received this e-mail in error please notify > immediately the sender and delete the original email received, any > attachments and all copies from your system. > > > > > > -- > Nitin Pawar > > ******************************* > > This e-mail contains information for the intended recipient only. It may > contain proprietary material or confidential information. If you are not > the intended recipient you are not authorised to distribute, copy or use > this e-mail or any attachment to it. Murex cannot guarantee that it is > virus free and accepts no responsibility for any loss or damage arising > from its use. If you have received this e-mail in error please notify > immediately the sender and delete the original email received, any > attachments and all copies from your system. > --001a11c2fad06507ae04ff820e8f Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
You might want to write a custom SerDe with a simple logic= to convert string to integer.

--Bala G.


On Thu, Jul 31, 2= 014 at 3:29 AM, CHEBARO Abdallah <Abdallah.CHEBARO@murex.com&= gt; wrote:

I know it will be a compl= ete string. I am trying to =E2=80=9Cinteger=E2=80=9D without the quotations= .

=C2=A0

From: Nitin Pa= war [mailto:ni= tinpawar432@gmail.com]
Sent: Thursday, July 31, 2014 1:28 PM
To: user@h= ive.apache.org
Subject: Re: Input

=C2=A0

if you specified ; as your delimiter then "abc&= quot; will be complete string and not abc only.

=C2=A0

Take a look at csv fileformat if you want to use pro= per comma delimited feature=C2=A0

=C2=A0<= /p>

On Thu, Jul 31, 2014 at 3:44 PM, CHEBARO Abdallah &l= t;Abdallah.= CHEBARO@murex.com> wrote:

Hello,

=C2=A0

I am using Hive and trying to read from a txt file.<= u>

=C2=A0

I have an input like the following: =E2=80=9Cstring= =E2=80=9D;=E2=80=9Dstring=E2=80=9D;=E2=80=9Dinteger=E2=80=9D.=

=C2=A0

First, I specified that the row fields are delimited= by a semi-column. Is it possible to read the integer without the quotation= s?

=C2=A0

Thank you

*******************************

This e-mail contains information for the inten= ded recipient only. It may contain proprietary material or=C2=A0confidentia= l information. If you are not the intended recipient you are not authorised = to=C2=A0distribute, copy or use this e-mail or any attachment to it.=C2=A0<= /span>Murex=C2=A0cannot guarantee that it is virus free and accepts no responsibility for any loss or damage arising fr= om its use.=C2=A0If you have received this e-mail in error please=C2=A0noti= fy immediately=C2=A0the sender=C2=A0and=C2=A0delete the original email rece= ived, any attachments and all copies from your system.



=C2=A0

--
Nitin Pawar

*******************************

<= p style=3D"line-height:19px;margin:0px 0px 0.0001pt;font-size:11pt;font-fam= ily:Calibri,sans-serif;color:#2a2a2a"> This e-mail contains information for the intended recipie= nt only. It may contain proprietary material or=C2=A0confidential informati= on. If you are not the intended recipient you are not authorised to=C2=A0di= stribute, copy or use this e-mail or any attachment to it.=C2=A0Murex=C2=A0cannot guarantee that it is virus = free and accepts no responsibility for any loss or damage arising from its = use.=C2=A0If you have received this e-mail in error please=C2=A0notify imme= diately=C2=A0the sender=C2=A0and=C2=A0delete the original email received, a= ny attachments and all copies from your system.


--001a11c2fad06507ae04ff820e8f--