[jira] [Commented] (SQOOP-3168) Sqoop Saved Job feature of overwriting job argument at execution time is not working in Sqoop1.4.6CDH 5.8.0

["Anna Szonyi (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SQOOP-3168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15960653#comment-15960653 ] 

Anna Szonyi commented on SQOOP-3168:
------------------------------------

Hi,

Unfortunately this is a bug that was introduced with SQOOP-2779 and later fixed by SQOOP-2896. As for a workaround: there is none, besides patching it with the fix of SQOOP-2896, as for CDH 5.8.0, only creating new jobs or upgrading to 5.8.5+ would solve it, as that is where the fix was first backported.

Apologies and Regards,
Anna

> Sqoop Saved Job feature of overwriting job argument at execution time is not working in Sqoop1.4.6CDH 5.8.0
> -----------------------------------------------------------------------------------------------------------
>
>                 Key: SQOOP-3168
>                 URL: https://issues.apache.org/jira/browse/SQOOP-3168
>             Project: Sqoop
>          Issue Type: Bug
>            Reporter: Hemendra Yadav
>
> Hi,
> I have created one sqoop saved job using below command ::
> sqoop job --create <job_name> -- import --connect <url> --driver com.mysql.jdbc.Driver --username <username> --password <password> --table <table> --target-dir location1 --fields-terminated-by , --escaped-by \\ -m 1
>  
> I need to put the data to different location so while execution i have provided new location in below command::
> sqoop job --exec jobname1 -- --target-dir location_new
>  But it still picks up the target directory from the saved job i.e. location1.
> I am currently using sqoop 1.4.6 CDH 5.8.0 version. When i have checked the sqoop code it seems that in sqoop CDH 5.8.0  code for overwritting job argument is removed from the method "private int execJob(SqoopOptions opts)" in the class "org.apache.sqoop.tool.JobTool" due to issue "https://issues.apache.org/jira/browse/SQOOP-2779".
>  When i have executed the same command using sqoop 1.4.6 CDH 5.7.3 it is able to overwrite the target directory and working as expected.
> Can you please suggest any workaround how to import data to a different target directory while executing sqoop saved job.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)