[
https://issues.apache.org/jira/browse/SQOOP-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Szabolcs Vasas reassigned SQOOP-3198:
-------------------------------------
Assignee: Szabolcs Vasas (was: Eric Lin)
> Fix DirectMySQLExportTest and OracleExportTest
> ----------------------------------------------
>
> Key: SQOOP-3198
> URL: https://issues.apache.org/jira/browse/SQOOP-3198
> Project: Sqoop
> Issue Type: Improvement
> Affects Versions: 1.4.6
> Reporter: Szabolcs Vasas
> Assignee: Szabolcs Vasas
> Labels: newbie
>
> 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.4.14#64029)
