[
https://issues.apache.org/jira/browse/TAJO-836?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14027462#comment-14027462
]
ASF GitHub Bot commented on TAJO-836:
-------------------------------------
Github user jihoonson commented on a diff in the pull request:
https://github.com/apache/tajo/pull/15#discussion_r13635248
--- Diff:
tajo-core/src/main/antlr4/org/apache/tajo/engine/parser/SQLParser.g4 ---
@@ -68,8 +68,8 @@ schema_statement
;
index_statement
- : CREATE (u=UNIQUE)? INDEX n=identifier ON t=table_name
(m=method_specifier)?
- LEFT_PAREN s=sort_specifier_list RIGHT_PAREN p=param_clause?
+ : CREATE (u=UNIQUE)? INDEX identifier ON table_name (method_specifier)?
+ LEFT_PAREN sort_specifier_list RIGHT_PAREN param_clause?
(where_clause)?
--- End diff --
Right. That's what I mean.
Here is the document of the create index statement in Postgresql.
http://www.postgresql.org/docs/9.1/static/sql-createindex.html
I think that we will add the tablespace parameter later.
> create index support
> --------------------
>
> Key: TAJO-836
> URL: https://issues.apache.org/jira/browse/TAJO-836
> Project: Tajo
> Issue Type: Sub-task
> Components: operator/expression, physical operator, planner/optimizer
> Reporter: Jihoon Son
> Assignee: Jihoon Son
> Priority: Minor
> Fix For: 0.9.0
>
> Attachments: TAJO-836.patch, TAJO-836_2.patch, TAJO-836_3.patch
>
>
> The synopsis is as follows.
> {noformat}
> CREATE [ UNIQUE ] INDEX [ name ] ON table [ USING method ]
> ( { column | ( expression ) } [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
> [, ...] )
> [ WHERE predicate ]
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
