Typo: > You might want to write a custom **UDF** with a simple logic to convert string to integer.
--Bala G. On Thu, Jul 31, 2014 at 12:12 PM, Bala Krishna Gangisetty < [email protected]> wrote: > 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. >> > >
