FAQ
Hi,

I am using sqoop to import data from mysql to the my hadoop cluster.

I am trying to run an initial import using widgets table in hadoopguide
database. But it gets hung at "beginning import of widgets"

hadoop@hadoop-name:~$ sqoop import --connect
jdbc:mysql://localhost/hadoopguide --table widgets -m 1 --verbose
12/08/27 15:07:09 INFO manager.MySQLManager: Preparing to use a MySQL
streaming resultset.
12/08/27 15:07:09 INFO tool.CodeGenTool: Beginning code generation
12/08/27 15:07:09 INFO manager.SqlManager: Executing SQL statement: SELECT
t.* FROM `widgets` AS t LIMIT 1
12/08/27 15:07:09 INFO manager.SqlManager: Executing SQL statement: SELECT
t.* FROM `widgets` AS t LIMIT 1
12/08/27 15:07:09 INFO orm.CompilationManager: HADOOP_HOME is
/usr/lib/hadoop
Note:
/tmp/sqoop-hadoop/compile/1a77d93defecafbdf3334a8b542e8c6b/widgets.java
uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
12/08/27 15:07:10 INFO orm.CompilationManager: Writing jar file:
/tmp/sqoop-hadoop/compile/1a77d93defecafbdf3334a8b542e8c6b/widgets.jar
12/08/27 15:07:10 WARN manager.MySQLManager: It looks like you are
importing from mysql.
12/08/27 15:07:10 WARN manager.MySQLManager: This transfer can be faster!
Use the --direct
12/08/27 15:07:10 WARN manager.MySQLManager: option to exercise a
MySQL-specific fast path.
12/08/27 15:07:10 INFO manager.MySQLManager: Setting zero DATETIME behavior
to convertToNull (mysql)
12/08/27 15:07:10 INFO mapreduce.ImportJobBase: Beginning import of widgets


And it remains at this point only. This table contains only 3 lines, so
should get imported in seconds but it is taking forever.

Thanks,
Megha

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupscm-users @
categorieshadoop
postedAug 27, '12 at 7:12p
activeAug 27, '12 at 7:12p
posts1
users1
websitecloudera.com
irc#hadoop

1 user in discussion

Megha Agrawal: 1 post

People

Translate

site design / logo © 2022 Grokbase