@Arun Byresh Sqoop allows you to define saved jobs. A saved job records the configuration information required to execute a Sqoop command at a later time. It is not possible to access saved Sqoop jobs and edit them via the command line. The best workaround for this functionality is the override function, whereby it is possible to override certain properties by adding one extra -- after the --exec call, e.g. $ sqoop job --exec myjob -- --query "select * from test" --last-value 3 ... View more

Also refer to this post on how to handle this https://community.hortonworks.com/questions/92891/sqoop-netezza-connector-syntax-for-ctrl-chars-trun.html#answer-93068 ... View more

@Pengcheng Fang Please Refer to extra arguments section of Sqoop guide on how to handle control characters and skip on errors. http://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_extra_arguments_3 ... View more