[
https://issues.apache.org/jira/browse/TAJO-21?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13618733#comment-13618733
]
Hyunsik Choi commented on TAJO-21:
----------------------------------
A nice find! Yes, this is a bug to be fixed.
> CREATE EXTERNAL TABLE should 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
