Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-9656

Create Index Failed without WITH DEFERRED REBUILD

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 0.13.0, 0.14.0, 1.0.0
    • Fix Version/s: None
    • Component/s: Indexing
    • Labels:
      None

      Description

      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?

        Attachments

          Activity

            People

            • Assignee:
              ctang Chaoyu Tang
              Reporter:
              willddy Will Du
            • Votes:
              3 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated: