Member since
06-30-2016
5
Posts
1
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2585 | 04-05-2017 02:49 PM |
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