I have table in MySQL with 2 columns until yesterday. The columns are
I have imported this data into HDFS yesterday itself as a file. Today we added a new column to the table in MySQL called
salary. The table looks like below.
1,Raj 2,Jack 3,Jill,2000 4,Nick,3000
Now I have done Incremental import on this table as a file.
Part-m-00000 file contains
Part-m-00001 file contains
Now I created a new table in MySQL with same schema as Original MySQL table with columns
When I do sqoop export only last 2 rows are getting inserted to the new table in MySQL .
How can I reflect all the rows to be inserted to the table.