[
https://issues.apache.org/jira/browse/SQOOP-313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13117827#comment-13117827
]
Hudson commented on SQOOP-313:
------------------------------
Integrated in Sqoop-jdk-1.6 #32 (See
[https://builds.apache.org/job/Sqoop-jdk-1.6/32/])
SQOOP-313: Support for multiple column names for update keys
(Arvind Prabhakar via Bilung Lee)
blee : http://svn.apache.org/viewvc/?view=rev&rev=1177481
Files :
* /incubator/sqoop/trunk/src/docs/man/sqoop-export.txt
* /incubator/sqoop/trunk/src/docs/user/export.txt
* /incubator/sqoop/trunk/src/java/com/cloudera/sqoop/manager/ConnManager.java
* /incubator/sqoop/trunk/src/java/com/cloudera/sqoop/manager/OracleManager.java
*
/incubator/sqoop/trunk/src/java/com/cloudera/sqoop/mapreduce/AvroExportMapper.java
*
/incubator/sqoop/trunk/src/java/com/cloudera/sqoop/mapreduce/JdbcExportJob.java
*
/incubator/sqoop/trunk/src/java/com/cloudera/sqoop/mapreduce/JdbcUpdateExportJob.java
*
/incubator/sqoop/trunk/src/java/com/cloudera/sqoop/mapreduce/JdbcUpsertExportJob.java
*
/incubator/sqoop/trunk/src/java/com/cloudera/sqoop/mapreduce/OracleUpsertOutputFormat.java
*
/incubator/sqoop/trunk/src/java/com/cloudera/sqoop/mapreduce/UpdateOutputFormat.java
*
/incubator/sqoop/trunk/src/test/com/cloudera/sqoop/TestAvroImportExportRoundtrip.java
* /incubator/sqoop/trunk/src/test/com/cloudera/sqoop/TestExportUpdate.java
*
/incubator/sqoop/trunk/src/test/com/cloudera/sqoop/testutil/BaseSqoopTestCase.java
*
/incubator/sqoop/trunk/src/test/com/cloudera/sqoop/testutil/ExportJobTestCase.java
> 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
