Scribd
Upload
29 views1 page

Incremental Import

This command uses Sqoop to import data from the employees table in a MySQL database into HDFS, appending any new or updated data since the last import with employee_id values greater than 108 to the /data/emp/ directory in incremental mode.

Uploaded by

Lokesh Makwane
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
29 views1 page

Incremental Import

This command uses Sqoop to import data from the employees table in a MySQL database into HDFS, appending any new or updated data since the last import with employee_id values greater than 108 to the /data/emp/ directory in incremental mode.

Uploaded by

Lokesh Makwane
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

sqoop import --connect

jdbc:mysql://localhost:3306/vaibhav --username root


--password hr --table employees --target-dir /data/emp/
--incremental append --check-column employee_id
--last-value 108

You might also like