Hi, I have table Service Requests (SRs) which is having 10k records as of today trying to implement incremental logic so that when i run tomorrow need to capture only newly inserted and updated records Table structure : row_id (unique), SR# , Sr_owner,sr_group,sr_last_update_date (timestamp) Approache : 1) created sqoop job as below sqoop job --create sr_table -- import --connect "jdbc:sqlserver://localhost:1431;database=test;username=root;password=welcome1" --query 'select * from sr_table where $CONDITIONS' --target-dir /data/sr/sr_table --append --check-column SR_LAST_UPD --incremental lastmodified --last-value '1900-01-01' --split-by ROW_ID 2) While running this for the first time its working fine (Full data or full load) 3) If I re-execute it again its not comparing he Upper Bound value with last run time (SR_LAST_UPD) Was able to follow this (https://github.com/abajwa-hw/single-view-demo/blob/master/singleview-mysql-advanced-23.md) I'm looking for more dynamic way of comparing the sqoop job execution time to compare with sr_last_upd value Thanks - ... View more