You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Markus Kemper (JIRA)" <ji...@apache.org> on 2016/08/29 18:40:20 UTC

[jira] [Commented] (SQOOP-1906) Export support for mixed update/insert against db2

    [ https://issues.apache.org/jira/browse/SQOOP-1906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15446704#comment-15446704 ] 

Markus Kemper commented on SQOOP-1906:
--------------------------------------

Hello [~xieshiju] and [~jarcec],

Is the blocking issue on this Jira the creation of a review board entry for the patch?

Thanks, [~markuskemper@me.com]

>  Export support for mixed  update/insert against db2
> ----------------------------------------------------
>
>                 Key: SQOOP-1906
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1906
>             Project: Sqoop
>          Issue Type: Improvement
>          Components: connectors
>    Affects Versions: 1.4.5
>         Environment: RedHat6.4+Sqoop1.4.5+Hadoop2.4.1+Hive0.13.0+DB2 10.5
>            Reporter: xieshiju
>            Assignee: xieshiju
>              Labels: features
>             Fix For: 1.4.7
>
>         Attachments: SQOOP-1906.patch
>
>   Original Estimate: 504h
>  Remaining Estimate: 504h
>
> The DB2 connector need to implemented the option --update-mode allowinsert. 
> option --update-mode allowinsert which can be used when loading into a table that is not empty. 
> In allowinsert mode export will try to update the row but if ithe row does not exist it will insert it. Without this option only rows that already exist in the table will be updated and any new rows are ignored.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)