First 1500 records are imported and then how to import the next 1500 records to the existing data.
I have to import fixed number of rows in incremental import in sqoop, i do not know how to do this. I am trying locally to test incremental import functionality with this code----------
sqoop import --connect jdbc:mysql://localhost/customer --username root -P
--query 'select * from customer WHERE $CONDITIONS ORDER BY cst_no LIMIT 1500'
-m 1 --incremental append --check-column cst_no
I am able to import first 1500 records with this command and now I want to import the next 1500 records to the existing data. How to do this, any help please?