You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Qian Xu (JIRA)" <ji...@apache.org> on 2015/03/17 03:07:43 UTC

[jira] [Updated] (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:all-tabpanel ]

Qian Xu updated SQOOP-1906:
---------------------------
    Fix Version/s:     (was: 1.4.6)
                   1.4.7

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