hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-4251) Indices can't be built on tables whose schema info comes from SerDe
Date Mon, 08 Jul 2013 04:43:49 GMT

    [ 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

Mime
View raw message