执行hive sql 报错“FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. “

yidianyidei

于 2020-08-10 00:46:54 发布

阅读量5.5k

点赞数 2

CC 4.0 BY-SA版权

分类专栏：大数据中遇到坑文章标签： hive hadoop

本文链接：https://blog.youkuaiyun.com/yidianyidei/article/details/107903483

在执行Hive SQL创建表时遇到错误'FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.'，问题源于warehouse目录不是目录。解决方法是检查/user/hive/warehouse路径，确保其为目录，如果不是，将其更改为目录。" 116276053,10849560,C语言实现扫雷游戏,"['游戏开发', 'C语言编程']

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

执行hive 报错

…bin/hive
hive> create table student(id int, name string);

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.hadoop.fs.FileAlreadyExistsException Parent path is not a directory: /user/hive/warehouse student
        at org.apache.hadoop.hdfs.server.namenode.FSDirMkdirOp.unprotectedMkdir(FSDirMkdirOp.java:231)
        at org.apache.hadoop.hdfs.server.namenode.FSDirMkdirOp.createSingleDirectory(FSDirMkdirOp.java:191)
        at org.apache.hadoop.hdfs.server.namenode.FSDirMkdirOp.createChildrenDirectories(FSDirMkdirOp.java:166)
        at org.apache.hadoop.hdfs.server.namenode.FSDirMkdirOp.mkdirs(FSDirMkdirOp.java:97)
        at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirs(FSNamesystem.java:3894)
        at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.mk