Hello! I'm trying to schedule a sqoop import with Oozie but when I run the job I get the given error message:
-Stdout: >>> Invoking Sqoop command line now >>> 4219 [main] WARN org.apache.sqoop.tool.SqoopTool - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration. Intercepting System.exit(1) <<< Invocation of Main class completed <<< Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1] Oozie Launcher failed, finishing Hadoop job gracefully Oozie Launcher, uploading action data to HDFS sequence file: hdfs://arnaldo01:8020/user/hdfs/oozie-oozi/0000060-140815151915320-oozie-oozi-W/job_sqoop--sqoop/action-data.seq Oozie Launcher ends - Stderr: Log Type: stderr Log Length: 398 log4j:ERROR Could not find value for key log4j.appender.CLA log4j:ERROR Could not instantiate appender named "CLA". log4j:ERROR Could not find value for key log4j.appender.CLA log4j:ERROR Could not instantiate appender named "CLA". No such sqoop tool: sqoop. See 'sqoop help'. Intercepting System.exit(1) Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1] -Syslog: Log Type: syslog Log Length: 2793 2014-09-10 10:59:55,753 WARN [main] org.apache.hadoop.conf.Configuration: job.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval; Ignoring. 2014-09-10 10:59:55,792 WARN [main] org.apache.hadoop.conf.Configuration: job.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts; Ignoring. 2014-09-10 10:59:56,636 INFO [main] org.apache.hadoop.metrics2.impl.MetricsConfig: loaded properties from hadoop-metrics2.properties 2014-09-10 10:59:56,701 INFO [main] org.apache.hadoop.metrics2.impl.MetricsSinkAdapter: Sink ganglia started 2014-09-10 10:59:56,781 INFO [main] org.apache.hadoop.metrics2.impl.MetricsSystemImpl: Scheduled snapshot period at 10 second(s). 2014-09-10 10:59:56,781 INFO [main] org.apache.hadoop.metrics2.impl.MetricsSystemImpl: MapTask metrics system started 2014-09-10 10:59:56,792 INFO [main] org.apache.hadoop.mapred.YarnChild: Executing with tokens: 2014-09-10 10:59:56,792 INFO [main] org.apache.hadoop.mapred.YarnChild: Kind: mapreduce.job, Service: job_1409171169512_0306, Ident: (org.apache.hadoop.mapreduce.security.token.JobTokenIdentifier@43f52b8<mailto:org.apache.hadoop.mapreduce.security.token.JobTokenIdentifier@43f52b8>) 2014-09-10 10:59:56,826 INFO [main] org.apache.hadoop.mapred.YarnChild: Kind: RM_DELEGATION_TOKEN, Service: 10.167.71.118:8050, Ident: (owner=hdfs, renewer=oozie mr token, realUser=oozie, issueDate=1410357586692, maxDate=1410962386692, sequenceNumber=266, masterKeyId=15) 2014-09-10 10:59:56,889 INFO [main] org.apache.hadoop.mapred.YarnChild: Sleeping for 0ms before retrying again. Got null now. 2014-09-10 10:59:57,328 INFO [main] org.apache.hadoop.mapred.YarnChild: mapreduce.cluster.local.dir for child: /hadoop/yarn/local/usercache/hdfs/appcache/application_1409171169512_0306 2014-09-10 10:59:57,562 WARN [main] org.apache.hadoop.conf.Configuration: job.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval; Ignoring. 2014-09-10 10:59:57,570 WARN [main] org.apache.hadoop.conf.Configuration: job.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts; Ignoring. 2014-09-10 10:59:58,117 INFO [main] org.apache.hadoop.conf.Configuration.deprecation: session.id is deprecated. Instead, use dfs.metrics.session-id 2014-09-10 10:59:58,789 INFO [main] org.apache.hadoop.mapred.Task: Using ResourceCalculatorProcessTree : [ ] 2014-09-10 10:59:59,001 INFO [main] org.apache.hadoop.mapred.MapTask: Processing split: hdfs://arnaldo01:8020/user/hdfs/oozie-oozi/0000060-140815151915320-oozie-oozi-W/job_sqoop--sqoop/input/dummy.txt:0+5 2014-09-10 10:59:59,027 INFO [main] org.apache.hadoop.mapred.MapTask: numReduceTasks: 0 2014-09-10 10:59:59,074 INFO [main] org.apache.hadoop.conf.Configuration.deprecation: mapred.job.id is deprecated. Instead, use mapreduce.job.id How do I fix this error? Thanks! Thiago Henrique S. Bento B2W Digital / B2W Labs +55 11 3454-3024 thiago.be...@b2wdigital.com<mailto:thiago.be...@b2wdigital.com> ________________________________ Esta mensagem pode conter informa??es confidenciais e somente o indiv?duo ou entidade a quem foi destinada pode utiliz?-la. A transmiss?o incorreta da mensagem n?o acarreta a perda de sua confidencialidade. Caso esta mensagem tenha sido recebida por engano, solicitamos que o fato seja comunicado ao remetente e que a mensagem seja eliminada de seu sistema imediatamente. ? vedado a qualquer pessoa que n?o seja o destinat?rio usar, revelar, distribuir ou copiar qualquer parte desta mensagem. Ambiente de comunica??o sujeito a monitoramento. This message may include confidential information and only the intended addresses have the right to use it as is, or any part of it. A wrong transmission does not break its confidentiality. If you've received it because of a mistake or erroneous transmission, please notify the sender and delete it from your system immediately. This communication environment is controlled and monitored. B2W Digital
