You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Abraham Elmahrek (JIRA)" <ji...@apache.org> on 2015/05/13 01:56:01 UTC
[jira] [Assigned] (SQOOP-2356) Sqoop2: Derby upgrade should
automatically rename jobs that have conflicting names
[ https://issues.apache.org/jira/browse/SQOOP-2356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abraham Elmahrek reassigned SQOOP-2356:
---------------------------------------
Assignee: Abraham Elmahrek
> Sqoop2: Derby upgrade should automatically rename jobs that have conflicting names
> ----------------------------------------------------------------------------------
>
> Key: SQOOP-2356
> URL: https://issues.apache.org/jira/browse/SQOOP-2356
> Project: Sqoop
> Issue Type: Bug
> Reporter: Abraham Elmahrek
> Assignee: Abraham Elmahrek
> Fix For: 1.99.7
>
>
> The following should work:
> {code}
> 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;
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)