[SQOOP-313] Multiple column names to be included in --update-key argument with SQOOP export (update)

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.4.0-incubating
• Assignee: Arvind Prabhakar
• Reporter: Bejoy KS
• Created: 10/Aug/11 10:07
• Updated: 21/Oct/11 17:43
• Resolved: 30/Sep/11 01:58

Description

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.