[SQOOP-2356] Sqoop2: Derby upgrade should automatically rename jobs that have conflicting names

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.99.7
• Assignee: Abraham Elmahrek
• Reporter: Abraham Elmahrek
• Created: 12/May/15 21:31
• Updated: 15/May/15 08:49
• Resolved: 15/May/15 08:20

Description

The following should work:

CREATE SEQUENCE job_renamer AS BIGINT START WITH 0;
UPDATE SQOOP.SQ_JOB set SQB_NAME = SQB_NAME || '_' || CAST(NEXT VALUE FOR job_renamer AS CHAR(100)) where SQB_ID IN (
SELECT j1.SQB_ID FROM SQOOP.SQ_JOB AS j1 INNER JOIN ( SELECT SQB_NAME FROM SQOOP.SQ_JOB GROUP BY (SQB_NAME) HAVING COUNT > 1 ) AS j2 ON j1.SQB_NAME = j2.SQB_NAME
);
drop SEQUENCE job_renamer RESTRICT;

Issue Links

• links to: RB