[
https://issues.apache.org/jira/browse/HIVE-4251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13701766#comment-13701766
]
Hudson commented on HIVE-4251:
------------------------------
Integrated in Hive-trunk-h0.21 #2185 (See
[https://builds.apache.org/job/Hive-trunk-h0.21/2185/])
HIVE-4251 : Indices can't be built on tables whose schema info comes from
SerDe (Mark Wagner via Ashutosh Chauhan) (Revision 1500452)
Result = FAILURE
hashutosh :
http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1500452
Files :
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java
* /hive/trunk/ql/src/test/queries/clientpositive/index_serde.q
* /hive/trunk/ql/src/test/results/clientpositive/index_serde.q.out
> 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
> Fix For: 0.12.0
>
> 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
