Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop, mail # user - Sqoop is at stuck


Copy link to this message
-
Sqoop is at stuck
hakki buyukcengiz 2013-04-24, 06:58
Hi,

I had running sqoop export commands like:

sqoop export --connect 'jdbc:oracle:thin:@<ip>:<port>:<service>' --username
DUMMY --password 'DUMMY' --table TEST_STG --export-dir
/user/export_import/SQOOP --fields-terminated-by '\t' --lines-terminated-by
'\n'

This command had run successfully but suddenly it become falling into
stuck. When I start, it prints the normal message like this:

[root@devnode1 ~]# sqoop export --connect
'jdbc:oracle:thin:@<ip>:<port>:<service>'
--username DUMMY --password 'DUMMY' --table TEST_STG --export-dir
/user/export_import/SQOOP --fields-terminated-by '\t' --lines-terminated-by
'\n'
13/04/24 09:46:19 WARN tool.BaseSqoopTool: Setting your password on the
command-line is insecure. Consider using -P instead.
13/04/24 09:46:19 INFO manager.SqlManager: Using default fetchSize of 1000
13/04/24 09:46:19 INFO tool.CodeGenTool: Beginning code generation
13/04/24 09:46:31 INFO manager.OracleManager: Time zone has been set to GMT
13/04/24 09:46:31 INFO manager.SqlManager: Executing SQL statement: SELECT
t.* FROM TEST_STG t WHERE 1=0
13/04/24 09:46:31 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is
/opt/cloudera/parcels/CDH-4.2.0-1.cdh4.2.0.p0.10/bin/../lib/hadoop-0.20-mapreduce
13/04/24 09:46:31 INFO orm.CompilationManager: Found hadoop core jar at:
/opt/cloudera/parcels/CDH-4.2.0-1.cdh4.2.0.p0.10/bin/../lib/hadoop-0.20-mapreduce/hadoop-2.0.0-mr1-cdh4.2.0-core.jar
Note:
/tmp/sqoop-root/compile/13ac98badc5d4c43ab02815245c500e8/TEST_STG.java uses
or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
13/04/24 09:46:33 INFO orm.CompilationManager: Writing jar file:
/tmp/sqoop-root/compile/13ac98badc5d4c43ab02815245c500e8/TEST_STG.jar
13/04/24 09:46:33 INFO mapreduce.ExportJobBase: Beginning export of
TEST_STG_HAKKI_4
13/04/24 09:46:34 INFO manager.OracleManager: Time zone has been set to GMT
And after this point sqoop gives no further message. It inserts no record
to the db too.
What can be the reason for this?

Thanks,

--
Hakki Buyukcengiz
TR
+
Jarek Jarcec Cecho 2013-04-24, 15:11
+
hakki buyukcengiz 2013-04-24, 15:14
+
Jarek Jarcec Cecho 2013-04-24, 15:47
+
Venkat Ranganathan 2013-04-24, 19:15
+
hakki buyukcengiz 2013-04-26, 07:38
+
Felix GV 2013-04-26, 13:46
+
Jarek Jarcec Cecho 2013-04-26, 17:42
+
hakki buyukcengiz 2013-04-27, 18:54
+
Felix GV 2013-04-27, 20:28