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 < [email protected]> wrote: > I know it will be a complete string. I am trying to “integer” without > the quotations. > > > > *From:* Nitin Pawar [mailto:[email protected]] > *Sent:* Thursday, July 31, 2014 1:28 PM > *To:* [email protected] > *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 < > [email protected]> wrote: > > Hello, > > > > I am using Hive and trying to read from a txt file. > > > > I have an input like the following: “string”;”string”;”integer”. > > > > 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. >
