Hi, I'm using Sqoop to extract some data that contains double-quotes which I want to escape.
My data looks like: This is just some "test" data When I run sqoop it extracts the data as: This is just some """"test"""" data I'm using the following parameters when calling sqoop: --fields-terminated-by , --enclosed-by '\"' --escaped-by '\"' --optionally-enclosed-by '\"' I have tried removing the --optionally-enclosed-by and --enclosed-by parameters but sqoop still extracts the data with 4 double-quotes instead of just 2. Does anyone know what I am doing wrong? Thanks! -td