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

Cannot create INDEX on TABLE in HIVE 0.12

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 0.12.0
    • Fix Version/s: None
    • Component/s: Indexing
    • Labels:
      None
    • Environment:

      hadoop-0.23.9

      Description

      executing:
      CREATE INDEX idx ON TABLE cdrtest (caller) AS 'COMPACT' WITH DEFERRED REBUILD;

      ends with:
      FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Table not found default_cdrtest_idx_

      table:
      hive> describe cdrtest;
      OK
      caller string None
      calling string None
      unixtime string None
      duration int None
      calltype int None
      sequence int None
      Time taken: 0.254 seconds, Fetched: 6 row(s)

      I tried many other index names but it always end with this problem. What am i doing wrong?

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                JIV Juraj Volentier
              • Votes:
                1 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: