Sqoop
  1. Sqoop
  2. SQOOP-313

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

    Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.4.0-incubating
    • Component/s: None
    • Labels:
      None

      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.

      1. SQOOP-313-1.patch
        33 kB
        Arvind Prabhakar
      2. SQOOP-313.patch
        32 kB
        Arvind Prabhakar

        Activity

        Bejoy KS created issue -
        Arvind Prabhakar made changes -
        Field Original Value New Value
        Fix Version/s 1.4.0 [ 12317345 ]
        Arvind Prabhakar made changes -
        Assignee Arvind Prabhakar [ aprabhakar ]
        Arvind Prabhakar made changes -
        Attachment SQOOP-313.patch [ 12497036 ]
        Arvind Prabhakar made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Fix Version/s 1.4.0 [ 12317345 ]
        Arvind Prabhakar made changes -
        Attachment SQOOP-313-1.patch [ 12497104 ]
        Bilung Lee made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Arvind Prabhakar made changes -
        Fix Version/s 1.4.0-incubating [ 12317345 ]

          People

          • Assignee:
            Arvind Prabhakar
            Reporter:
            Bejoy KS
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development