Hello Hive Users,
After I execute below mention Alter statement, I get beloe mentioned error.
Even though log shows that index file was moved to trash, I see index file
present, however I am not able to understand why i am getting error.
*ALTER INDEX TAB_INDEX ON TABLE REBUILD;*
*2013-01-08 15:30:46,602 Stage-1 map = 100%, reduce = 100%, Cumulative CPU
*2013-01-08 15:30:47,612 Stage-1 map = 100%, reduce = 100%, Cumulative CPU
*MapReduce Total cumulative CPU time: 3 seconds 410 msec*
*Ended Job = job_201301072354_0115*
*Loading data to table TABLE_index_table*
*rmr: DEPRECATED: Please use 'rm -r' instead.*
*Moved: 'hdfs://host:8020/hive/optqc5d.db/TABLE_index_table' to trash at:
*Invalid alter operation: Unable to alter index.*
*FAILED: Execution Error, return code 1 from
Good wishes,always !
Shreepadma Venugopalan 2013-01-08, 22:16
Santosh Achhra 2013-01-09, 00:41