Sqoop Export Update Issue

Excuted the following Query:
sqoop export
–connect jdbc:mysql://ms.itversity.com:3306/retail_export
–username retail_user
–password itversity
–export-dir /user/chaluvadiv/orders/order_items
–table order_items_cv
–update-key oitem_id
–update-mode allowinsert
This inserted 172198 records.
Again executed the above query and to my wonder inserted another set of 172198 records.
But actually expecting no more records to be added.
Please explain what caused this to happen ?


@VENKATESWARLU_CHALUV You can refer to this below topic. I hope this will help you to resolve the issue.