sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bilung Lee (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-327) Mixed update/insert export support for OracleManager
Date Thu, 01 Sep 2011 05:58:09 GMT
Mixed update/insert export support for OracleManager
----------------------------------------------------

                 Key: SQOOP-327
                 URL: https://issues.apache.org/jira/browse/SQOOP-327
             Project: Sqoop
          Issue Type: New Feature
            Reporter: Bilung Lee
            Assignee: Bilung Lee


Currently Sqoop export job runs in insert mode (default) or update mode (with --update-key
option). When in insert mode, all data are inserted and when in update mode, all data are
updated in existing table. This leaves out the use case where some data may need to be updated
while the rest needs to be inserted.

It also causes problems
- When in insert mode, new data may cause constraint violations if they exist already.
- When in update mode, it could result in silent dropping of records that do not match the
update key.

The idea is to introduce a new "upsert" mode to update records if they exist in table already
or to insert records if they do not exist yet.


--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message