[HIVE-5902] Cannot create INDEX on TABLE in HIVE 0.12

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

Environment

hadoop-0.23.9

• Assignee: Unassigned
• Reporter: Juraj Volentier
• Created: 27/Nov/13 11:04
• Updated: 14/Mar/15 09:08

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?

Issue Links

• relates to: HIVE-9639 Create Index failed in Multiple version of Hive running