Only 1 record with delimiters exported with Sqoop



I have the following import and export commands. Import is successful but only 1 record is exported. Can anyone please check whats the issue here.

Import command:

sqoop import --connect jdbc:mysql://localhost/retail_db --username cloudera --table order_items --warehouse-dir /user/cloudera --optionally-enclosed-by ‘"’ --fields-terminated-by | --lines-terminated-by : --num-mappers 1;

Export command:

sqoop export --connect jdbc:mysql://localhost/retail_db_export --username cloudera --table order_items --export-dir /user/cloudera/order_items --optionally-enclosed-by ‘"’ --fields-terminated-by | --lines-terminated-by : --num-mappers 1;