Mark Wagner created HIVE-4251: --------------------------------- Summary: Indices can't be built on tables who's schema info comes from SerDe Key: HIVE-4251 URL: https://issues.apache.org/jira/browse/HIVE-4251 Project: Hive Issue Type: Bug Affects Versions: 0.11.0, 0.10.1 Reporter: Mark Wagner Assignee: Mark Wagner
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. {code} 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 {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira