Samet Karadag created SQOOP-3480:
------------------------------------
Summary: if enclosed-by and escaped-by characters are both double
quote (\"). This causes duplicate escapes and thus duplicate characters in
douplequotes
Key: SQOOP-3480
URL: https://issues.apache.org/jira/browse/SQOOP-3480
Project: Sqoop
Issue Type: Bug
Reporter: Samet Karadag
if enclosed-by and escaped-by characters are both double quote (\"). This
causes duplicate escapes and thus duplicate characters in douple quotes.
Example;
gcloud dataproc jobs submit hadoop --cluster=sqoop --region=europe-west4
--class=org.apache.sqoop.Sqoop --jars=$libs -- import
-Dmapreduce.job.user.classpath.first=true --connect=jdbc:****
--target-dir=gs://my-oracle-extract/EMPLOYEES --table=HR.EMPLOYEES
--enclosed-by '\"' --escaped-by \" --fields-terminated-by '|' --null-string ''
--null-non-string '' --as-textfile
causes this field; <test field " >
to enclosed and escaped by this; <"test field """"">
Which has 2 double quotes
Bigquery requires double quotes as escap char. and field should be also
enclosed by " for newlines.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
