oozie 调用 sqoop，出现这个错误 Failing Oozie Launcher

[hfmbook]

Sqoop command arguments :
import
--connect
jdbc:mysql://cdh5.hadoop.com:3306/test
--username
root
--password
123456
--table
epc_partgroup
--num-mappers
1
--fields-terminated-by
"\t"
--delete-target-dir
--hive-database
hive_gary
--hive-import
--hive-table
epc_partgroup
=================================================================

>>> Invoking Sqoop command line now >>>

4924 [main] WARN org.apache.sqoop.tool.SqoopTool - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.
4971 [main] INFO org.apache.sqoop.Sqoop - Running Sqoop version: 1.4.5-cdh5.3.6
5000 [main] WARN org.apache.sqoop.tool.BaseSqoopTool - Setting your password on the command-line is insecure. Consider using -P instead.
5025 [main] WARN org.apache.sqoop.ConnFactory - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.
5172 [main] INFO org.apache.sqoop.manager.MySQLManager - Preparing to use a MySQL streaming resultset.
5180 [main] INFO org.apache.sqoop.tool.CodeGenTool - Beginning code generation
5864 [main] INFO org.apache.sqoop.manager.SqlManager - Executing SQL statement: SELECT t.* FROM `epc_partgroup` AS t LIMIT 1
5958 [main] INFO org.apache.sqoop.manager.SqlManager - Executing SQL statement: SELECT t.* FROM `epc_partgroup` AS t LIMIT 1
5966 [main] INFO org.apache.sqoop.orm.CompilationManager - HADOOP_MAPRED_HOME is /opt/soft/cdh5/hadoop-2.5.0-cdh5.3.6
13088 [main] INFO org.apache.sqoop.orm.CompilationManager - Writing jar file: /tmp/sqoop-gary/compile/7eb5d287f10f01ef33f03384f9dcf6b5/epc_partgroup.jar
13167 [main] INFO org.apache.sqoop.tool.ImportTool - Destination directory epc_partgroup deleted.
13167 [main] WARN org.apache.sqoop.manager.MySQLManager - It looks like you are importing from mysql.
13168 [main] WARN org.apache.sqoop.manager.MySQLManager - This transfer can be faster! Use the --direct
13168 [main] WARN org.apache.sqoop.manager.MySQLManager - option to exercise a MySQL-specific fast path.
13168 [main] INFO org.apache.sqoop.manager.MySQLManager - Setting zero DATETIME behavior to convertToNull (mysql)
13172 [main] INFO org.apache.sqoop.mapreduce.ImportJobBase - Beginning import of epc_partgroup
13225 [main] WARN org.apache.sqoop.mapreduce.JobBase - SQOOP_HOME is unset. May not be able to find all job dependencies.
14223 [main] INFO org.apache.sqoop.mapreduce.db.DBInputFormat - Using read commited transaction isolation
Heart beat
48069 [main] INFO org.apache.sqoop.mapreduce.ImportJobBase - Transferred 2.6914 KB in 34.8306 seconds (79.1259 bytes/sec)
48113 [main] INFO org.apache.sqoop.mapreduce.ImportJobBase - Retrieved 102 records.
48220 [main] INFO org.apache.sqoop.manager.SqlManager - Executing SQL statement: SELECT t.* FROM `epc_partgroup` AS t LIMIT 1
48323 [main] INFO org.apache.sqoop.hive.HiveImport - Loading uploaded data into Hive
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://cdh5.hadoop.com:8020/user/gary/oozie-gary/0000007-151227120318126-oozie-gary-W/sqoop-node--sqoop/action-data.seq

Oozie Launcher ends

我看到 两个压yarn上运行的进程已经成功，最后导入hive的时候出现了这个错误

[hfmbook]

引用 1 楼 liu_yulong 的回复:

不知道你的具体环境是什么，找不到具体原因

oozie 调用sqoop导入mysql数据到 hive [code] import --connect jdbc:mysql://cdh5.hadoop.com:3306/test --username root --password 123456 --table epc_partgroup --num-mappers 1 --fields-terminated-by "\t" --delete-target-dir --hive-database hive_gary --hive-import --hive-table epc_partgroup [code]

[悠悠-我心]

不知道你的具体环境是什么，找不到具体原因

[cd20121111yt]

你好 我也遇到同样问题，请问你是怎么解决的后来。

[hfmbook]

$SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.

[Kumquatlemon]

同样的错误 84723 [uber-SubtaskRunner] INFO org.apache.sqoop.hive.HiveImport - Loading uploaded data into Hive 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

[随风心境]

我也遇到这个错误，请问解决了吗，能不能指点一下，谢谢非常感谢

[随风心境]

引用 6 楼 Kumquatlemon 的回复:

同样的错误 84723 [uber-SubtaskRunner] INFO org.apache.sqoop.hive.HiveImport - Loading uploaded data into Hive 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

请问解决了吗

[hfmbook]

$SQOOP_CONF_DIR has not been set in the environment. 没有设置这个

[weixin_42392100]

使用oozie调要sqoop从关系型数据库到数据到hive，分两步：第一步是将数据导入到hdfs 的账户目录下/user/***/tablename；第二步是将该文件load到对应的表里面。你这个应该是第二步出了问题，原因在于你的Hue账户不是OS账户，没有权限移动文件。