Member since
04-04-2017
3
Posts
0
Kudos Received
0
Solutions
04-05-2017
02:53 PM
This works sqoop-export \ -Dmapreduce.job.queuename=analyst \ -Dmapreduce.job.name=web_event.sqp \ --direct \ --connect jdbc:netezza://fdhgfgjhkj:5480/dghnfgjhnfgj \ --table fgjhfgjj \ --username rjrjtru \ -P \ --export-dir /dataset-ste/secure-p/inbound/rtujrjryiutydidti/ \ --input-escaped-by'\\' \ --input-fields-terminated-by'\t' \ --input-lines-terminated-by'\n' \ --input-null-string'\\N' \ --input-null-non-string'\\N' \ -m 4 \ --verbose \ -- \ --ctrl-chars \ --trunc-string \ -max-errors 20
... View more
04-04-2017
07:54 PM
Hi I am trying to run sqoop command with options --ctrl-chars --trunc-string
I am getting an errors saying
17/04/04 14:23:09 ERROR tool.BaseSqoopTool: Error parsing arguments for export:
17/04/04 14:23:09 ERROR tool.BaseSqoopTool: Unrecognized argument: -ctrl-chars
17/04/04 14:23:09 ERROR tool.BaseSqoopTool: Unrecognized argument: -trunc-string
17/04/04 14:23:09 ERROR tool.BaseSqoopTool: Unrecognized argument: -max-errors
Sqoop version 1.4.6.2.5.3.0-37
Hortonworks HDP 2.5.3
My sqoop command is as below.
sqoop-export \
-Dmapreduce.job.queuename=analyst \
-Dmapreduce.job.name=web_event.sqp \
--direct \
--connect jdbc:netezza://fdhgfgjhkj:5480/dghnfgjhnfgj \
--table fgjhfgjj \
--username rjrjtru \
-P \
--export-dir /dataset-ste/secure-p/inbound/rtujrjryiutydidti/ \
--input-escaped-by '\\' \
--input-fields-terminated-by '\t' \
--input-lines-terminated-by '\n' \
--input-null-string '\\N' \
--input-null-non-string '\\N' \
-m 4 \
--verbose \
--ctrl-chars
--trunc-string
-max-errors #0
... View more
Labels:
- Labels:
-
Apache Hadoop
-
Apache Sqoop