sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arvind Prabhakar (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SQOOP-313) Multiple column names to be included in --update-key argument with SQOOP export (update)
Date Wed, 10 Aug 2011 18:16:27 GMT

     [ https://issues.apache.org/jira/browse/SQOOP-313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Arvind Prabhakar updated SQOOP-313:
-----------------------------------

    Fix Version/s: 1.4.0

> 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
>             Fix For: 1.4.0
>
>
> 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message