hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arthur Boender <>
Subject RE: FileAlreadyExistsException Parent path is not a directory
Date Mon, 25 Feb 2013 13:39:24 GMT
Is log the file or the directory..

Creating an external table over a directory might me easier, as it would apply to any log
file placed into the folder.

If log is the file try

LOCATION '/a/b/c/d/';

If log is a directory try
LOCATION '/a/b/c/d/log/';

Gr Arthur

From: Abhishek Gayakwad []
Sent: maandag 25 februari 2013 13:34
Subject: FileAlreadyExistsException Parent path is not a directory

I am using Hive 0.9.0, while creating external table

create external table if not exists table1


Id int,

Name string,

PName string,

timestamp string


row format delimited fields terminated by '\t'

LOCATION '/a/b/c/d/log';

and getting this error

FAILED: Error in metadata: MetaException(message:Got exception: org.apache.hadoop.fs.FileAlreadyExistsException
Parent path is not a directory: /a/b/c/d/log log
        at org.apache.hadoop.hdfs.server.namenode.FSDirectory.mkdirs(
        at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirsInternal(
        at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirsInt(
        at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirs(
        at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.mkdirs(
        at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.mkdirs(
        at org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(
        at org.apache.hadoop.ipc.ProtobufRpcEngine$Server$
        at org.apache.hadoop.ipc.RPC$
        at org.apache.hadoop.ipc.Server$Handler$
        at org.apache.hadoop.ipc.Server$Handler$
        at Method)
        at org.apache.hadoop.ipc.Server$
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

Does any body know the reason why this is happening

View raw message