You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by DU DU <wi...@gmail.com> on 2015/02/10 17:44:34 UTC

Fwd: Hive Index without WITH DEFERRED REBUILD

Can we create Hive index without specifying "WITH DEFERRED REBUILD"? Right
now, it reports following errors.


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.


Is this a bug?


In addition, I found drop index never check metadata and log here
<https://issues.apache.org/jira/browse/HIVE-9638>


And issues of index in Hive 1.0.0 here
<https://issues.apache.org/jira/browse/HIVE-9639>


Can someone verify this and provide workaround?


Thanks,
Will