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

["Zoltan Haindrich (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-2895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zoltan Haindrich resolved HIVE-2895.
------------------------------------
    Resolution: Won't Fix

indexing is removed in 3.0

> 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
>            Priority: Major
>              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 was sent by Atlassian JIRA
(v7.6.3#76005)