Import error using sqoop


#1

sqoop import-all-tables --connect “jdbc:mysql://ip-172-31-20-247/retail_db” --username sqoopuser --password ********* --target-dir /home/soutam20182163/retail_stage.db --compress --compression-codec snappy --as-avrodatafile -m 1;

SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/hdp/2.6.5.0-292/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBin
der.class]
SLF4J: Found binding in [jar:file:/usr/hdp/2.6.5.0-292/accumulo/lib/slf4j-log4j12.jar!/org/slf4j/impl/StaticLoggerBinder.c
lass]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
19/01/08 09:17:49 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.6.5.0-292
19/01/08 09:17:50 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instea
d.
19/01/08 09:17:50 ERROR tool.BaseSqoopTool: Error parsing arguments for import-all-tables:
19/01/08 09:17:50 ERROR tool.BaseSqoopTool: Unrecognized argument: --target-dir
19/01/08 09:17:50 ERROR tool.BaseSqoopTool: Unrecognized argument: /home/soutam20182163/retail_stage.db
19/01/08 09:17:50 ERROR tool.BaseSqoopTool: Unrecognized argument: --compress
19/01/08 09:17:50 ERROR tool.BaseSqoopTool: Unrecognized argument: --compression-codec
19/01/08 09:17:50 ERROR tool.BaseSqoopTool: Unrecognized argument: snappy
19/01/08 09:17:50 ERROR tool.BaseSqoopTool: Unrecognized argument: --as-avrodatafile
19/01/08 09:17:50 ERROR tool.BaseSqoopTool: Unrecognized argument: -m
19/01/08 09:17:50 ERROR tool.BaseSqoopTool: Unrecognized argument: 1


#2

Hi @Soutam_Mandal,

The error is self explanatory. Requesting you to check the error message once. You will find the answer yourself.