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
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