[
https://issues.apache.org/jira/browse/SQOOP-1906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15446704#comment-15446704
]
Markus Kemper edited comment on SQOOP-1906 at 8/29/16 7:12 PM:
---------------------------------------------------------------
Hello [~xieshiju] and [~jarcec],
Is the blocking issue on this Jira the creation of a review board entry for the
patch?
The IBM url below suggests that IBM supports this capability however have not
found any commit or code for IBM in Db2Manager.java that has the
"upsertTable()" method. Any assistance in understanding if this capability is
supported with IBM would be appreciated.
https://www.ibm.com/support/knowledgecenter/SSPT3X_4.1.0/com.ibm.swg.im.infosphere.biginsights.product.doc/doc/bi_sqoop.html
IBM-specific backported patches and changes
Export support for mixed update/insert against DB2.
Thanks, [[email protected]]
was (Author: [email protected]):
Hello [~xieshiju] and [~jarcec],
Is the blocking issue on this Jira the creation of a review board entry for the
patch?
Thanks, [[email protected]]
> 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)
