You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Szabolcs Vasas (JIRA)" <ji...@apache.org> on 2017/06/14 15:37:00 UTC
[jira] [Updated] (SQOOP-3198) Fix DirectMySQLExportTest and
OracleExportTest
[ https://issues.apache.org/jira/browse/SQOOP-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Szabolcs Vasas updated SQOOP-3198:
----------------------------------
Description: Since (was: 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.)
> 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
>
> Since
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)