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
--target-dir sqoop/import_data/cstdb_import_incremental

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?

Tagged:
Sign In or Register to comment.