[ 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)