08-28-2017 04:56 PM
My database has a timestamp column on the basis of which Iam performing my sqoop incremental import with last modified clause.
If I am giving last modified check column value as 11am it doesn't retrieves the records which were inserted at 11am it imports records after that.
How do I import the records processed at 11am.
I don't want to have any duplicate records or any missing records.
08-28-2017 07:45 PM
its is always recommended to run this as sqoop job so that you will have your last value being recorded automatically.
would you consider performing
which specifies the column to be examined when determining which rows to import.
will insert all the new rows based on the last value