[HIVE-9639] Create Index failed in Multiple version of Hive running

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.0.0
• Component/s: Indexing, Parser
• Assignee: Unassigned
• Reporter: Will Du
• Created: 10/Feb/15 16:36
• Updated: 14/Mar/15 09:08

Description

Create Index in either type COMPACT or BITMAP does not work on version 1.0 when I install it in the Quick Start CDH VM used to have Hive v0.13.0 running. The same query can run successfully in 0.13.0 and 0.14.0 alone

CREATE INDEX idx_id_employee_id
ON TABLE employee_id (employee_id)
AS 'COMPACT'
WITH DEFERRED REBUILD;

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

Issue Links

• is related to: HIVE-5902 Cannot create INDEX on TABLE in HIVE 0.12