a newline in column data ruin Hive

[mahender bigdata]

Hi,

We are facing issue while loading/reading data from file which has line 
delimiter characters like \n  has part of column data. When we try to 
query the Hive table, data with \n gets split up into multiple rows. Is 
there a way to tell hive to skip escape character like \n ( row 
delimiter or field delimiter) within in column data.  We saw LINE 
Terminator property in create table syntax, but currently it accepts 
only \n. Is there a way to have custom line terminator property.


Thanks in advance