[
https://issues.apache.org/jira/browse/HIVE-4251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13701439#comment-13701439
]
Ashutosh Chauhan commented on HIVE-4251:
----------------------------------------
+1
> Indices can't be built on tables whose 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.10.0, 0.10.1, 0.11.0
> Reporter: Mark Wagner
> Assignee: Mark Wagner
> Attachments: HIVE-4251.1.patch, HIVE-4251.2.patch
>
>
> 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
