hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: MSCK REPAIR TABLE
Date Thu, 27 Mar 2014 10:03:01 GMT
Without error stack, very hard to get whats wrong

will it be possible for you to run it via hive cli and grab some logs
through there ?


On Thu, Mar 27, 2014 at 3:29 PM, fab wol <darkwolli32@gmail.com> wrote:

> Hey Nitin,
>
> HiveServer2 Log unfurtantely says nothing:
>
> Mon Mar 24 17:41:18 CET 2014 hiveserver2 stopped, pid 2540
> Mon Mar 24 17:43:22 CET 2014 hiveserver2 started, pid 2554
> Hive history
> file=/tmp/mapr/hive_job_log_97715747-63cd-4789-9b2e-a8b0d544cdf9_
> 2102956370.txt
> OK
> Thu Mar 27 10:52:48 CET 2014 hiveserver2 stopped, pid 2554
> Thu Mar 27 10:55:52 CET 2014 hiveserver2 started, pid 2597
>
> Cheers
> Wolli
>
>
> 2014-03-27 10:04 GMT+01:00 Nitin Pawar <nitinpawar432@gmail.com>:
>
> can you grab more logs from hiveserver2 log file?
>>
>>
>> On Thu, Mar 27, 2014 at 2:31 PM, fab wol <darkwolli32@gmail.com> wrote:
>>
>>> Hey everyone,
>>>
>>> I have a table with currently 5541 partitions. Daily there are 14
>>> partitions added. I will switch the update for the metastore from "msck
>>> repair table" to "alter table add partition", since its performing better,
>>> but sometimes this might fail, and i need the "msck repair table" command.
>>> But unfortunately its not working anymore with this table size it seems:
>>>
>>> 0: jdbc:hive2://clusterXYZ-> use <DB_NAME>;
>>> No rows affected (1.082 seconds)
>>> 0: jdbc:hive2://clusterXYZ-> set
>>> hive.metastore.client.socket.timeout=6000;
>>> No rows affected (0.029 seconds)
>>> 0: jdbc:hive2://clusterXYZ-> MSCK REPAIR TABLE <TABLENAME>;
>>> Error: Error while processing statement: FAILED: Execution Error, return
>>> code 1 from org.apache.hadoop.hive.ql.exec.DDLTask (state=08S01,code=1)
>>> Error: Error while processing statement: FAILED: Execution Error, return
>>> code 1 from org.apache.hadoop.hive.ql.exec.DDLTask (state=08S01,code=1)
>>>
>>> anyone had luck with getting this to work? As you can see, I already
>>> raised the time until the Thrift Timeout kicks in, but this error is
>>> happening even before the time runs off ...
>>>
>>> Cheers
>>> Wolli
>>>
>>
>>
>>
>> --
>> Nitin Pawar
>>
>
>


-- 
Nitin Pawar

Mime
View raw message