[jira] [Commented] (HIVE-5902) Cannot create INDEX on TABLE in HIVE 0.12

["Will Du (JIRA)" <ji...@apache.org>]

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

Will Du commented on HIVE-5902:
-------------------------------

pls. refer https://issues.apache.org/jira/browse/HIVE-9656
My guess is that you have multiple version of Hive running in the same cluster.

> Cannot create INDEX on TABLE in HIVE 0.12
> -----------------------------------------
>
>                 Key: HIVE-5902
>                 URL: https://issues.apache.org/jira/browse/HIVE-5902
>             Project: Hive
>          Issue Type: Bug
>          Components: Indexing
>    Affects Versions: 0.12.0
>         Environment: hadoop-0.23.9
>            Reporter: Juraj Volentier
>
> executing:
> CREATE INDEX idx ON TABLE cdrtest (caller) AS 'COMPACT' WITH DEFERRED REBUILD;
> ends with:
> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Table not found default__cdrtest_idx__
> table:
> hive> describe cdrtest;
> OK
> caller                  string                  None
> calling                 string                  None
> unixtime                string                  None
> duration                int                     None
> calltype                int                     None
> sequence                int                     None
> Time taken: 0.254 seconds, Fetched: 6 row(s)
> I tried many other index names but it always end with this problem. What am i doing wrong?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)