Hi, i had tried to create the table by "LINES terminated by '\001' " and it is giving me the error
Error in semantic analysis: 3:66 LINES TERMINATED BY only supports newline '\n' right now. Error encountered near token ''\001'' CREATE TABLE xmlgw4 ( transactionid string, typeid string, sentxml string,receivedxml string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\001' STORED AS TEXTFILE; instead of '\n' i am using '\001' because i have an xml value , which i want to store in hive that invludes \n values.. using hive version : hive-0.8.1 any suggestion? Regards.