[jira] [Created] (SQOOP-3480) if enclosed-by and escaped-by characters are both double quote (\"). This causes duplicate escapes and thus duplicate characters in douplequotes

["Samet Karadag (Jira)" <ji...@apache.org>]

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)