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


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

        

Reply via email to