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 <[email protected]>:

> can you grab more logs from hiveserver2 log file?
>
>
> On Thu, Mar 27, 2014 at 2:31 PM, fab wol <[email protected]> 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
>

Reply via email to