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

Create Index Failed without WITH DEFERRED REBUILD

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 0.13.0, 0.14.0, 1.0.0
    • None
    • Indexing
    • 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

            ctang Chaoyu Tang
            willddy Will Du
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: