sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Szabolcs Vasas (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SQOOP-3198) Fix DirectMySQLExportTest and OracleExportTest
Date Wed, 14 Jun 2017 15:37:00 GMT

     [ 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)

Mime
View raw message