Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Index rebuild fails


+
Santosh Achhra 2013-01-08, 15:40
Copy link to this message
-
Re: Index rebuild fails
Hi Santosh,

The execution log will contain the stack trace of the exception that caused
the task to fail. It would help to look into the execution log and attach
it to the email.

Thanks.
Shreepadma
On Tue, Jan 8, 2013 at 7:40 AM, Santosh Achhra <[EMAIL PROTECTED]>wrote:

> 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 3.41 sec*
> *2013-01-08 15:30:47,612 Stage-1 map = 100%,  reduce = 100%, Cumulative
> CPU 3.41 sec*
> *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:
> hdfs://host:8020/user/saachhra/.Trash/Current*
> *Invalid alter operation: Unable to alter index.*
> *FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask*
>
> Good wishes,always !
> Santosh
>
+
Santosh Achhra 2013-01-09, 00:41