Please note that there is an escape chacter in the fields where the /t and /n are present.
________________________________ From: Raj Hadoop <hadoop...@yahoo.com> To: Hive <user@hive.apache.org> 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