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