[
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)
