Member since
09-06-2019
2
Posts
0
Kudos Received
0
Solutions
09-25-2019
08:24 AM
Hello, I´m trying using sqoop, to import / export but I have the following Error...
It is on a Sandbox Hortonworks 2.2.4.2.
could you help me please ?
Thank You -
[root@sandbox results]# sqoop import --connect jdbc:mysql://127.0.0.1/sqoop --username root --table result --target-dir /user/results10/ Warning: /usr/hdp/current/accumulo-client does not exist! Accumulo imports will fail. Please set $ACCUMULO_HOME to the root of your Accumulo installation. 19/09/25 15:06:54 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5.2.2.4.2-2 19/09/25 15:06:55 INFO manager.SqlManager: Using default fetchSize of 1000 19/09/25 15:06:55 INFO tool.CodeGenTool: Beginning code generation SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/hdp/2.2.4.2-2/hadoop/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/hdp/2.2.4.2-2/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/hdp/2.2.4.2-2/hive/lib/hive-jdbc-0.14.0.2.2.4.2-2-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] 19/09/25 15:06:57 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `result` AS t LIMIT 1 19/09/25 15:06:57 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `result` AS t LIMIT 1 19/09/25 15:06:57 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/hdp/2.2.4.2-2/hadoop-mapreduce Note: /tmp/sqoop-root/compile/93fe6f5c14ca1e75e534e47a32a3bcb1/result.java uses or overrides a deprecated API. Note: Recompile with -Xlint:deprecation for details. 19/09/25 15:07:03 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-root/compile/93fe6f5c14ca1e75e534e47a32a3bcb1/result.jar 19/09/25 15:07:04 WARN manager.MySQLManager: It looks like you are importing from mysql. 19/09/25 15:07:04 WARN manager.MySQLManager: This transfer can be faster! Use the --direct 19/09/25 15:07:04 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path. 19/09/25 15:07:04 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql) 19/09/25 15:07:04 INFO mapreduce.ImportJobBase: Beginning import of result 19/09/25 15:07:11 INFO impl.TimelineClientImpl: Timeline service address: http://sandbox.hortonworks.com:8188/ws/v1/timeline/ 19/09/25 15:07:11 INFO client.RMProxy: Connecting to ResourceManager at sandbox.hortonworks.com/10.0.2.15:8050 19/09/25 15:07:14 INFO ipc.Client: Retrying connect to server: sandbox.hortonworks.com/10.0.2.15:8050. Already tried 0 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=50, sleepTime=1000 MILLISECONDS) 19/09/25 15:07:15 INFO ipc.Client: Retrying connect to server: sandbox.hortonworks.com/10.0.2.15:8050. Already tried 1 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=50, sleepTime=1000 MILLISECONDS) 19/09/25 15:07:16 INFO ipc.Client: Retrying connect to server: sandbox.hortonworks.com/10.0.2.15:8050. Already tried 2 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=50, sleepTime=1000 MILLISECONDS) 19/09/25 15:07:17 INFO ipc.Client: Retrying connect to server: sandbox.hortonworks.com/10.0.2.15:8050. Already tried 3 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=50, sleepTime=1000 MILLISECONDS)
... View more
Labels:
- Labels:
-
Apache Sqoop