title: SQOOP incremental import: how it handles the data when a row is deleted from the database?
body: <p>Suppose I have an employee table with column ( emp_id, emp_name, emp_age , emp_update_ts ), updat_ts field is auto updated to current timestamp every time if there is an update on the table. now my question is :</p>
  
  <p>When I update/insert the row in the table and run incremental sqoop import with lastmodified it will make my database and the hdfs in sync but "what if the data is deleted from the table and then I run the sqoop incremental with lastmodified option ? will it also take care of deleting the data from the HDFS to keep them in sync Or there is any other way which can handle the delete situation ?    </p>