Sqoop Dsqoop export records per statement option

Question

In the following command, what is the use of "Dsqoop.export.records.per.statement=1"

sqoop export --driver com.teradata.jdbc.TeraDriver --connect "jdbc:teradata://localhost/database=dbname" --password "xxxx" --username "usser" --table "mytab_load" --num-mappers 1 --export-dir "/maprfs:/../../mytab_load" --input-fields-terminated-by '\t' -Dsqoop.export.records.per.statement=1 

Answer 1

Dsqoop.export.records.per.statement=1 is as the name suggests how many records or rows sqoop export at a time to mysql. So when you assign it to 1, you are telling sqoop to export 1 row at a time.