Update new sql data in sqoop

Question

Hi. I need some help with Sqoop. I had created an Sql table and imported it in Sqoop. Now I updated the MySql table and want to update the data in Sqoop also. But I don't want to use import because it will import the whole database which will take time. How can I update the new data?

Answer 1

You can use incremental for this. When you incremental import, only the new data or updated data in the Sql table will updated in Sqoop. 

Here's an example command to use incremental import: 

sqoop import --connect jdbc:mysql://localhost/sampl --username root -P --table stu --hbase-table student --column-family details --hbase-row-key id --incremental append --check-column id --last-value 5 -m 1