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