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

Reply via email to