[
https://issues.apache.org/jira/browse/TAJO-369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
JaeHwa Jung resolved TAJO-369.
------------------------------
Resolution: Won't Fix
This is not a bug.
Partition conditions must be located before table path as follows:
{code:xml}
create external table table1 (id int, name text, score float, type text)
using csv with ('csvfile.delimiter'='|')
PARTITION BY COLUMN (id)
location 'Xyz'
{code}
> Add CREATE EXTERNAL TABLE... BY PARTITION statement to parser
> -------------------------------------------------------------
>
> Key: TAJO-369
> URL: https://issues.apache.org/jira/browse/TAJO-369
> Project: Tajo
> Issue Type: Sub-task
> Components: parser
> Affects Versions: 0.8-incubating
> Reporter: JaeHwa Jung
> Assignee: JaeHwa Jung
> Fix For: 0.8-incubating
>
>
> I found parse error when I wrote 'CREATE EXTERNAL TABLE BY PARTITION'
> statement as follows:
> {code:xml}
> 2013-12-03 16:42:36,800 ERROR master.GlobalEngine
> (GlobalEngine.java:executeQuery(172)) -
> Stack Trace:
> org.apache.tajo.engine.parser.SQLSyntaxError: ERROR: mismatched input
> 'PARTITION' expecting <EOF>
> LINE 1:123 ... ON 'hdfs://localhost:9010/tajo/warehouse/sales_column3'
> PARTITION BY COLUMN(col1)
> at org.apache.tajo.engine.parser.SQLAnalyzer.parse(SQLAnalyzer.java:64)
> at
> org.apache.tajo.master.GlobalEngine.executeQuery(GlobalEngine.java:134)
> at
> org.apache.tajo.master.TajoMasterClientService$TajoMasterClientProtocolServiceHandler.submitQuery(TajoMasterClientService.java:131)
> at
> org.apache.tajo.ipc.TajoMasterClientProtocol$TajoMasterClientProtocolService$2.callBlockingMethod(TajoMasterClientProtocol.java:228)
> {code}
> SQLAnalyzer needs to support this statement.
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)
