Member since
06-30-2016
5
Posts
1
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1360 | 04-05-2017 02:49 PM |
04-12-2017
12:51 PM
@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
04-11-2017
07:04 PM
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
04-11-2017
07:01 PM
@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
04-05-2017
04:39 PM
In addition also set CLUSTER.OPERATOR if there are any operator roles defined in Ambari. Or else Cluster operators will not be able to login to Logsearch. This is how I set it up. AMBARI.ADMINISTRATOR, CLUSTER.ADMINISTRATOR, CLUSTER.OPERATOR, CLUSTER.USER
... View more
04-05-2017
02:49 PM
1 Kudo
Netezza driver with direct mode would support --ctrl-chars option.
Please make sure to use this option with preceeding --, like
sqoop import --direct --connect jdbc:netezza://<netezza_host>:5480/db --username user -P --table table --targe-dir hdfsdir \
– --ctrl-chars --crin-string --ignore-zero --trunc-string options
... View more