Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
0.10.0, 0.11.0, 0.10.1
-
None
-
None
Description
Building indices on tables who get the schema information from the deserializer (e.g. Avro backed tables) doesn't work because when the column is checked to exist, the correct API isn't used.
hive> describe doctors; OK # col_name data_type comment number int from deserializer first_name string from deserializer last_name string from deserializer Time taken: 0.215 seconds, Fetched: 5 row(s) hive> create index doctors_index on table doctors(number) as 'compact' with deferred rebuild; FAILED: Error in metadata: java.lang.RuntimeException: Check the index columns, they should appear in the table being indexed. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask