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.cheb...@murex.com> 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