Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> How to load /t /n file to Hive

Copy link to this message
Re: How to load /t /n file to Hive
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
>   Hi,
> 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
> fields.
> 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.
> Thanks,
> Raj
Nitin Pawar