You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Lefty Leverenz (JIRA)" <ji...@apache.org> on 2015/02/12 02:49:11 UTC
[jira] [Commented] (HIVE-9656) Create Index Failed without WITH
DEFERRED REBUILD
[ 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)