Member since
03-02-2016
3
Posts
5
Kudos Received
0
Solutions
03-03-2016
04:59 PM
1 Kudo
Thanks @Shishir Saxena and @Predrag Minovic @Predrag Minovic Thank you but if I don't use any append or merge-key its throwing error as below With the below job definition sqoop is able to pick the date dynamically hopefully this should not be a problem? ERROR tool.ImportTool: Error during import: --merge-key or --append is required when using --incremental lastmodified and the output directory exists. sqoop job --create SRs-- import --connect "jdbc:sqlserver://localhost:1431;database=xx;username=root;password=welcome1" --query 'select * from sr_table where $CONDITIONS' --target-dir /data/sr/sr_table --append --check-column LAST_UPD --incremental lastmodified --last-value '2016-03-03 15:56:47.92' --split-by ROW_ID
... View more