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.


Thanks,
Will

Reply via email to