[jira] [Created] (SQOOP-3158) Columns added to Mysql after initial sqoop import, export back to table with same schema fails

[viru reddy (JIRA)]

viru reddy created SQOOP-3158:
---------------------------------

             Summary: Columns added to Mysql after initial sqoop import, export 
back to table with same schema fails 
                 Key: SQOOP-3158
                 URL: https://issues.apache.org/jira/browse/SQOOP-3158
             Project: Sqoop
          Issue Type: Test
          Components: connectors/hdfs, connectors/mysql
            Reporter: viru reddy


I have table in MySQL with 2 columns until yesterday. The columns are id and 
name.

1,Raj
2,Jack

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

1,Raj
2,Jack

Part-m-00001 file contains

3,Jill,2000
4,Nick,3000

Now I created a new table in MySQL with same schema as Original MySQL table 
with columns id name and salary.

When I do sqoop export only last 2 rows are getting inserted to the new table 
in MySQL  and the sqoop export fails

How can I reflect all the rows to be inserted to the table.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)