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
