[ https://issues.apache.org/jira/browse/SQOOP-3158?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16043260#comment-16043260 ]
Hudson commented on SQOOP-3158: ------------------------------- SUCCESS: Integrated in Jenkins build Sqoop-hadoop200 #1111 (See [https://builds.apache.org/job/Sqoop-hadoop200/1111/]) SQOOP-3158: Columns added to Mysql after initial sqoop import, export (annaszonyi: [https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=b0f391e75154be86f95378ab141f6dd1b3b59475]) * (edit) src/test/org/apache/sqoop/TestExportUsingProcedure.java * (edit) src/test/com/cloudera/sqoop/TestExport.java * (edit) src/java/org/apache/sqoop/orm/ClassWriter.java > 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: Improvement > Affects Versions: 1.4.6 > Reporter: viru reddy > Assignee: Eric Lin > Labels: newbie > Attachments: SQOOP-3158.2.patch, SQOOP-3158.3.patch, > SQOOP-3158.4.patch, SQOOP-3158.patch > > > 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)