[ https://issues.apache.org/jira/browse/HIVE-9639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Damien Carol updated HIVE-9639: ------------------------------- Description: Create Index in either type COMPACT or BITMAP does not work on version 1.0. The same query can run successfully in 0.13.0 and 0.14.0 {code:sql} CREATE INDEX idx_id_employee_id ON TABLE employee_id (employee_id) AS 'COMPACT' WITH DEFERRED REBUILD; {code} {noformat} FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Table not found default__employee_id_idx_id_employee_id__ {noformat} was: Create Index in either type COMPACT or BITMAP does not work on version 1.0. The same query can run successfully in 0.13.0 and 0.14.0 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__ > Create Index failed in Hive 1.0 > ------------------------------- > > Key: HIVE-9639 > URL: https://issues.apache.org/jira/browse/HIVE-9639 > Project: Hive > Issue Type: Bug > Components: Indexing, Parser > Affects Versions: 1.0.0 > Reporter: Will Du > > Create Index in either type COMPACT or BITMAP does not work on version 1.0. > The same query can run successfully in 0.13.0 and 0.14.0 > {code:sql} > CREATE INDEX idx_id_employee_id > ON TABLE employee_id (employee_id) > AS 'COMPACT' > WITH DEFERRED REBUILD; > {code} > {noformat} > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask. Table not found > default__employee_id_idx_id_employee_id__ > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)