[root@lnx2 ~]# su sqoop [sqoop@lnx2 root]$ sqoop export -P --username root --connect jdbc:mysql://Lnx0.localdomain.com/test --table weather --export-dir /user/horton/sfo_weather --validate Warning: /usr/hdp/2.3.4.0-3485/hbase does not exist! HBase imports will fail. Please set $HBASE_HOME to the root of your HBase installation. Warning: /usr/hdp/2.3.4.0-3485/accumulo does not exist! Accumulo imports will fail. Please set $ACCUMULO_HOME to the root of your Accumulo installation. 16/02/15 11:10:31 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.3.4.0-3485 Enter password: 16/02/15 11:10:35 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset. 16/02/15 11:10:35 INFO tool.CodeGenTool: Beginning code generation 16/02/15 11:10:36 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `weather` AS t LIMIT 1 16/02/15 11:10:37 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `weather` AS t LIMIT 1 16/02/15 11:10:37 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/hdp/2.3.4.0-3485/hadoop-mapreduce Note: /tmp/sqoop-sqoop/compile/edf92ed00cc89119ee0c6557151c49fc/weather.java uses or overrides a deprecated API. Note: Recompile with -Xlint:deprecation for details. 16/02/15 11:10:48 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-sqoop/compile/edf92ed00cc89119ee0c6557151c49fc/weather.jar 16/02/15 11:10:48 INFO mapreduce.ExportJobBase: Beginning export of weather 16/02/15 11:12:44 INFO impl.TimelineClientImpl: Timeline service address: http://lnx1.localdomain.com:8188/ws/v1/timeline/ 16/02/15 11:12:45 INFO client.RMProxy: Connecting to ResourceManager at lnx1.localdomain.com/192.168.122.40:8050 16/02/15 11:12:47 INFO hdfs.DFSClient: Created HDFS_DELEGATION_TOKEN token 601 for sqoop on ha-hdfs:HDPCA 16/02/15 11:13:02 INFO security.TokenCache: Got dt for hdfs://HDPCA; Kind: HDFS_DELEGATION_TOKEN, Service: ha-hdfs:HDPCA, Ident: (HDFS_DELEGATION_TOKEN token 601 for sqoop) 16/02/15 11:13:02 WARN token.Token: Cannot find class for token kind kms-dt 16/02/15 11:13:02 INFO security.TokenCache: Got dt for hdfs://HDPCA; Kind: kms-dt, Service: 192.168.0.102:9292, Ident: 00 05 73 71 6f 6f 70 02 72 6d 00 8a 01 52 e5 b4 d7 eb 8a 01 53 09 c1 5b eb 01 02 16/02/15 11:13:53 INFO input.FileInputFormat: Total input paths to process : 1 16/02/15 11:13:53 INFO input.FileInputFormat: Total input paths to process : 1 16/02/15 11:14:11 INFO mapreduce.JobSubmitter: number of splits:4 16/02/15 11:14:14 INFO mapreduce.JobSubmitter: Submitting tokens for job: job_1455551404320_0001 16/02/15 11:14:14 INFO mapreduce.JobSubmitter: Kind: HDFS_DELEGATION_TOKEN, Service: ha-hdfs:HDPCA, Ident: (HDFS_DELEGATION_TOKEN token 601 for sqoop) 16/02/15 11:14:14 WARN token.Token: Cannot find class for token kind kms-dt 16/02/15 11:14:14 WARN token.Token: Cannot find class for token kind kms-dt Kind: kms-dt, Service: 192.168.0.102:9292, Ident: 00 05 73 71 6f 6f 70 02 72 6d 00 8a 01 52 e5 b4 d7 eb 8a 01 53 09 c1 5b eb 01 02 16/02/15 11:14:24 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:26 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:28 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:30 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:32 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:34 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:36 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:38 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:40 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:42 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:44 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:47 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:49 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:51 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:53 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:55 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:14:58 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:00 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:03 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:05 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:07 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:09 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:11 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:13 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:16 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:18 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:20 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:22 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:24 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:26 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:28 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:30 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:32 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:34 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:36 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:38 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:40 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:42 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:45 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:47 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:49 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:51 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:53 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:55 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:15:57 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:00 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:02 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:05 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:07 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:09 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:11 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:14 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:16 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:18 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:20 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:22 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:24 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:26 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:28 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:30 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:32 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:34 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:36 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:38 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:40 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:42 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:44 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:46 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:48 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:50 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:52 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:55 INFO impl.YarnClientImpl: Application submission is not finished, submitted application application_1455551404320_0001 is still in NEW_SAVING 16/02/15 11:16:56 INFO impl.YarnClientImpl: Submitted application application_1455551404320_0001 16/02/15 11:16:57 INFO mapreduce.Job: The url to track the job: http://Lnx1.localdomain.com:8088/proxy/application_1455551404320_0001/ 16/02/15 11:16:57 INFO mapreduce.Job: Running job: job_1455551404320_0001 16/02/15 11:19:41 INFO mapreduce.Job: Job job_1455551404320_0001 running in uber mode : false 16/02/15 11:19:42 INFO mapreduce.Job: map 0% reduce 0% 16/02/15 11:22:10 INFO mapreduce.Job: map 75% reduce 0% 16/02/15 11:27:41 INFO mapreduce.Job: map 0% reduce 0% 16/02/15 11:27:41 INFO mapreduce.Job: Task Id : attempt_1455551404320_0001_m_000002_0, Status : FAILED AttemptID:attempt_1455551404320_0001_m_000002_0 Timed out after 300 secs 16/02/15 11:27:41 INFO mapreduce.Job: Task Id : attempt_1455551404320_0001_m_000000_0, Status : FAILED AttemptID:attempt_1455551404320_0001_m_000000_0 Timed out after 300 secs 16/02/15 11:27:41 INFO mapreduce.Job: Task Id : attempt_1455551404320_0001_m_000001_0, Status : FAILED AttemptID:attempt_1455551404320_0001_m_000001_0 Timed out after 300 secs 16/02/15 11:28:49 INFO mapreduce.Job: map 75% reduce 0% 16/02/15 11:34:10 INFO mapreduce.Job: Task Id : attempt_1455551404320_0001_m_000002_1, Status : FAILED AttemptID:attempt_1455551404320_0001_m_000002_1 Timed out after 300 secs 16/02/15 11:34:10 INFO mapreduce.Job: Task Id : attempt_1455551404320_0001_m_000000_1, Status : FAILED AttemptID:attempt_1455551404320_0001_m_000000_1 Timed out after 300 secs 16/02/15 11:34:10 INFO mapreduce.Job: Task Id : attempt_1455551404320_0001_m_000001_1, Status : FAILED AttemptID:attempt_1455551404320_0001_m_000001_1 Timed out after 300 secs 16/02/15 11:34:11 INFO mapreduce.Job: map 0% reduce 0% 16/02/15 11:34:59 INFO mapreduce.Job: map 50% reduce 0% 16/02/15 11:35:01 INFO mapreduce.Job: map 75% reduce 0% 16/02/15 11:40:10 INFO mapreduce.Job: Task Id : attempt_1455551404320_0001_m_000002_2, Status : FAILED AttemptID:attempt_1455551404320_0001_m_000002_2 Timed out after 300 secs 16/02/15 11:40:10 INFO mapreduce.Job: Task Id : attempt_1455551404320_0001_m_000000_2, Status : FAILED AttemptID:attempt_1455551404320_0001_m_000000_2 Timed out after 300 secs 16/02/15 11:40:10 INFO mapreduce.Job: Task Id : attempt_1455551404320_0001_m_000001_2, Status : FAILED AttemptID:attempt_1455551404320_0001_m_000001_2 Timed out after 300 secs 16/02/15 11:40:11 INFO mapreduce.Job: map 0% reduce 0% 16/02/15 11:41:09 INFO mapreduce.Job: map 25% reduce 0% 16/02/15 11:41:13 INFO mapreduce.Job: map 50% reduce 0% 16/02/15 11:41:15 INFO mapreduce.Job: map 75% reduce 0% 16/02/15 11:46:11 INFO mapreduce.Job: map 100% reduce 0% 16/02/15 11:46:18 INFO mapreduce.Job: Job job_1455551404320_0001 failed with state FAILED due to: Task failed task_1455551404320_0001_m_000002 Job failed as tasks failed. failedMaps:1 failedReduces:0 16/02/15 11:46:20 INFO mapreduce.Job: Counters: 10 Job Counters Failed map tasks=10 Killed map tasks=3 Launched map tasks=12 Other local map tasks=9 Rack-local map tasks=3 Total time spent by all maps in occupied slots (ms)=4707484 Total time spent by all reduces in occupied slots (ms)=0 Total time spent by all map tasks (ms)=4707484 Total vcore-seconds taken by all map tasks=4707484 Total megabyte-seconds taken by all map tasks=1205115904 16/02/15 11:46:20 WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead 16/02/15 11:46:20 INFO mapreduce.ExportJobBase: Transferred 0 bytes in 2,020.6226 seconds (0 bytes/sec) 16/02/15 11:46:20 WARN mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead 16/02/15 11:46:20 INFO mapreduce.ExportJobBase: Exported 0 records. 16/02/15 11:46:20 ERROR tool.ExportTool: Error during export: Export job failed! [sqoop@lnx2 root]$