Hello Everyone, When I tried to import the below data from an Oracle table (columns delimited by ',') to HDFS using the below mentioned Sqoop command,
12345,1-1SKCE5P,null,2013-10-11 06:23:22.0,2014-12-02 14:22:32.0,Switched "INFONET CONFERENCING" GSP P3519,null,OS sqoop import --connect jdbc:oracle:thin:@//xxxxx:xxxxx/xxxx_xxxx --username SUMAN --password-file /user/$USER/sqoop.password --table PRODUCTS --where "PRODUCT_KEY = '12345'" --fields-terminated-by , --escaped-by '\"' --optionally-enclosed-by '\"' --target-dir /user/SUMAN/PRODUCTS -m 1 the result is as below 12345,1-1SKCE5P,null,2013-10-11 06:23:22.0,2014-12-02 14:22:32.0,Switched """"INFONET CONFERENCING"""" GSP P3519,null,OS Why there are four-four double quotes present in the data (underlined) imported to HDFS? Instead of just two-two? Regards Suman
