You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ashutosh Chauhan (Commented) (JIRA)" <ji...@apache.org> on 2012/03/22 18:24:22 UTC

[jira] [Commented] (HIVE-2895) Hive cli silently fails to create index

    [ https://issues.apache.org/jira/browse/HIVE-2895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13235748#comment-13235748 ] 

Ashutosh Chauhan commented on HIVE-2895:
----------------------------------------

Dupe of HIVE-1496 ?
                
> Hive cli silently fails to create index
> ---------------------------------------
>
>                 Key: HIVE-2895
>                 URL: https://issues.apache.org/jira/browse/HIVE-2895
>             Project: Hive
>          Issue Type: Bug
>          Components: CLI, Indexing
>    Affects Versions: 0.7.0
>            Reporter: Mark Schnegelberger
>              Labels: newbie
>
> Hive CLI reports 'OK' to index creation, but no index is created as confirmed by later 'NoSuchObjectException' when later issuing index rebuild:
> [user@host dir]$ hive
> Hive history file=/tmp/user/hive_job_log_user_201203071111_11111111111.txt 
> hive> CREATE INDEX X ON TABLE Foo(startTime) as 'COMPACT' WITH DEFERRED REBUILD; 
> OK 
> Time taken: 2.353 seconds 
> hive> SHOW INDEXES ON Foo; 
> OK 
> Time taken: 0.182 seconds 
> hive> ALTER INDEX X ON Foo REBUILD; 
> FAILED: Error in semantic analysis: org.apache.hadoop.hive.ql.metadata.HiveException: NoSuchObjectException(message:default.Foo index=X not found) 
> hive>

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira