Re: a newline in column data ruin Hive

2016-02-23 Thread Nicholas Hakobian
We just had this problem recently with our data. There are actually 2 things you have to worry about. The reader (which the suggestion above seems to solve) and the intermediate stages (if using MR). We didn't have the issue with the reader since we use Parquet and Avro to store our data, but we ha

Re: a newline in column data ruin Hive

2016-02-23 Thread Rajit Saha
Hi Mahender, You can try ESCAPED BY '\\' Like a sample below CREATE EXTERNAL TABLE test ( a1 int, b1 string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ESCAPED BY '\\' STORED AS TEXTFILE LOCATION ‘'; Thanks Rajit From: mahender bigdata mailto:mahender.bigd...@outlook.com>> Reply-To: "us