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

最新推荐文章于 2023-07-12 23:17:49 发布

原创

最新推荐文章于 2023-07-12 23:17:49 发布 · 5.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#hive #hadoop

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

文章目录

执行hive 报错
找关键
解决

执行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.mkdirs(Name