Created on
09-25-2019
08:24 AM
- last edited on
09-25-2019
09:40 AM
by
VidyaSargur
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)
Created 09-25-2019 10:29 AM
Sqoop uses Mapreduce so make sure it's running and YARN then secondly you first validate that the database and table exist, follow the below steps
# mysql -u root -p[root_password]
mysql>show databases;
If the sqoop database exists then run
mysql> use sqoop;
mysql> show tables;
This MUST show the table result if it doesn't then your export cannot work and export command I don't see the MySQL database port default 3306 and the root password place holder -P or simple -p[root_password]
# sqoop import --connect jdbc:mysql://127.0.0.1:3306/sqoop --username root -P --table result --target-dir /user/results10/
Can you confirm the above and revert
Created 09-25-2019 10:29 AM
Sqoop uses Mapreduce so make sure it's running and YARN then secondly you first validate that the database and table exist, follow the below steps
# mysql -u root -p[root_password]
mysql>show databases;
If the sqoop database exists then run
mysql> use sqoop;
mysql> show tables;
This MUST show the table result if it doesn't then your export cannot work and export command I don't see the MySQL database port default 3306 and the root password place holder -P or simple -p[root_password]
# sqoop import --connect jdbc:mysql://127.0.0.1:3306/sqoop --username root -P --table result --target-dir /user/results10/
Can you confirm the above and revert