If your data contains new line chars, its better you write a custom map
reduce job and convert the data into a single line removing all unwanted
chars in column separator as well just having single new line char per line
On Sat, Sep 21, 2013 at 12:38 AM, Raj Hadoop <[EMAIL PROTECTED]> wrote:
> Please note that there is an escape chacter in the fields where the /t and
> /n are present.
> *From:* Raj Hadoop <[EMAIL PROTECTED]>
> *To:* Hive <[EMAIL PROTECTED]>
> *Sent:* Friday, September 20, 2013 3:04 PM
> *Subject:* How to load /t /n file to Hive
> 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 line /n character in some
> Is there any way to load this file using Hive load command? Or do i have
> to use a Custom Map Reduce (custom) Input format with java ? Please advise.