JaeHwa Jung created TAJO-21:
-------------------------------
Summary: CREATE EXTERNAL TABLE support a file path
Key: TAJO-21
URL: https://issues.apache.org/jira/browse/TAJO-21
Project: Tajo
Issue Type: Bug
Reporter: JaeHwa Jung
I was tried to setup Tajo using this guide:
http://tajo.incubator.apache.org/getting_started.html
However when I specified a file path for LOCATION in CREATE EXTERNAL TABLE
clause, I ended up with following error.
{code:title=using HDFS|borderStyle=solid}
tajo> create external table table1 (id int, name string, score float, type
string) using csv with ('csvfile.delimiter'='|') location '/data/input/table1'
Parent path is not a directory: /data/input/table1 table1
at
org.apache.hadoop.hdfs.server.namenode.FSDirectory.mkdirs(FSDirectory.java:1467)
at
org.apache.hadoop.hdfs.server.namenode.FSDirectory.addFile(FSDirectory.java:249)
at
org.apache.hadoop.hdfs.server.namenode.FSNamesystem.startFileInternal(FSNamesystem.java:1878)
at
org.apache.hadoop.hdfs.server.namenode.FSNamesystem.startFileInt(FSNamesystem.java:1757)
at
org.apache.hadoop.hdfs.server.namenode.FSNamesystem.startFile(FSNamesystem.java:1735)
at
org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.create(NameNodeRpcServer.java:429)
at
org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.create(ClientNamenodeProtocolServerSideTranslatorPB.java:271)
at
org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java:40732)
at
org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:454)
at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:1014)
at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1735)
at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:1731)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1441)
at org.apache.hadoop.ipc.Server$Handler.run(Server.java:1729)
{code}
{code:title=using local file system|borderStyle=solid}
tajo> create external table table1 (id int, name string, score float, type
string) using csv with ('csvfile.delimiter'='|') location
'file:/data/tajo/table1'
Mkdirs failed to create file://data/tajo/table1
{code}
If I write a directory name at LOCATION clause, I success to make Tajo table.
Buf I think Tajo to support a file path at LOCATION clause like Hive and must
update Tajo setup guide until Tajo support it.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
