[
https://issues.apache.org/jira/browse/HIVE-9656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14317383#comment-14317383
]
Lefty Leverenz commented on HIVE-9656:
--------------------------------------
CREATE INDEX syntax in the DDL wikidoc also shows WITH DEFERRED REBUILD as
optional.
* [LanguageManual DDL -- Create Index |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateIndex]
> Create Index Failed without WITH DEFERRED REBUILD
> -------------------------------------------------
>
> Key: HIVE-9656
> URL: https://issues.apache.org/jira/browse/HIVE-9656
> Project: Hive
> Issue Type: Bug
> Components: Indexing
> Affects Versions: 0.13.0, 0.14.0, 1.0.0
> Reporter: Will Du
>
> Create Hive index without specifying "WITH DEFERRED REBUILD" is failed with
> following error.
> CREATE INDEX table01_index ON TABLE table01 (column2)
> AS 'COMPACT';
> FAILED: Error in metadata: java.lang.RuntimeException: Please specify
> deferred rebuild using " WITH DEFERRED REBUILD ".
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask
> According to the design here
> https://cwiki.apache.org/confluence/display/Hive/IndexDev
> "WITH DEFERRED REBUILD" is optional, correct?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
