[
https://issues.apache.org/jira/browse/SQOOP-313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bilung Lee updated SQOOP-313:
-----------------------------
Resolution: Fixed
Status: Resolved (was: Patch Available)
Committed. Thanks, Arvind!
> Multiple column names to be included in --update-key argument with SQOOP
> export (update)
> ----------------------------------------------------------------------------------------
>
> Key: SQOOP-313
> URL: https://issues.apache.org/jira/browse/SQOOP-313
> Project: Sqoop
> Issue Type: New Feature
> Reporter: Bejoy KS
> Assignee: Arvind Prabhakar
> Attachments: SQOOP-313-1.patch, SQOOP-313.patch
>
>
> Currently the --update-key argument in SQOOP export (Updates) supports only
> one column name. But in most real time scenarios the target db table would
> have composite primary key hence in the SQL generated by SQOOP we may have to
> include more than one condition separated by AND in the WHERE clauses, ie the
> db UPDATE query generated should be like
> UPDATE .... SET ... WHERE PKColumn1 = '<value>' AND PKColumn2= '<value>' AND
> ...
> For this we need to modify --update-key argument to accomodate more that one
> column name which is separated using some separator like comma.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
