hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mich Talebzadeh" <m...@peridale.co.uk>
Subject Re: org.apache.hadoop.hive.ql.lockmgr.LockException: No record of lock could be found, may have timed out
Date Thu, 23 Apr 2015 16:28:11 GMT
Hi,

I am using Zookeeper

Thanks
Let your email find you with BlackBerry from Vodafone

-----Original Message-----
From: Alan Gates <alanfgates@gmail.com>
Date: Thu, 23 Apr 2015 08:48:01 
To: <user@hive.apache.org>
Reply-To: user@hive.apache.org
Subject: Re: org.apache.hadoop.hive.ql.lockmgr.LockException: No record of
 lock could be found, may have timed out

What lock or transaction manager are you using?

Alan.

> Mich Talebzadeh <mailto:mich@peridale.co.uk>
> April 23, 2015 at 8:19
>
> Hi all,
>
> Trying to do a direct load from RDBMS to Hive (not using Sqoop).
>
> It sends data in files of 9999 rows at a time.
>
> Concurrency is enabled. Using Oracle database as metastore. Out of 
> 300,000 rows managed to get in 227,106 rows
>
> hive> select count(1) from t;
>
> Total MapReduce CPU Time Spent: 8 seconds 650 msec
>
> OK
>
> 227106
>
> Time taken: 22.858 seconds, Fetched: 1 row(s)
>
> The successful load go through as
>
> Loading data to table asehadoop.rs_temp__0xe9bf1e0_t
>
> Table asehadoop.rs_temp__0xe9bf1e0_t stats: [numFiles=1, numRows=0, 
> totalSize=22361277, rawDataSize=0]
>
> OK
>
> Loading data to table asehadoop.rs_temp__0x2aaab40aade0_t
>
> Loading data to table asehadoop.rs_temp__0x2aaab015d670_t
>
> Table asehadoop.rs_temp__0x2aaab40aade0_t stats: [numFiles=1, 
> numRows=0, totalSize=22362397, rawDataSize=0]
>
> OK
>
> Query ID = hduser_20150423005858_6f616eb1-f0b3-4462-957d-a39ccc6393d9
>
> Total jobs = 3
>
> Launching Job 1 out of 3
>
> Number of reduce tasks is set to 0 since there's no reduce operator
>
> Table asehadoop.rs_temp__0x2aaab015d670_t stats: [numFiles=1, 
> numRows=0, totalSize=22363290, rawDataSize=0]
>
> However, I am getting the following hive error
>
> Query ID = hduser_20150423005858_6f1472d0-184d-42e9-a709-43cf63e709f0
>
> Total jobs = 3
>
> Launching Job 1 out of 3
>
> Number of reduce tasks is set to 0 since there's no reduce operator
>
> Starting Job = job_1429714224771_0041, Tracking URL = 
> http://rhes564:8088/proxy/application_1429714224771_0041/
>
> Kill Command = /home/hduser/hadoop/hadoop-2.6.0/bin/hadoop job  -kill 
> job_1429714224771_0041
>
> java.io.IOException: org.apache.hadoop.hive.ql.lockmgr.LockException: 
> No record of lock could be found, may have timed out
>
> Anyone has seen this error please?
>
> Thanks
>
> Mich Talebzadeh
>
> http://talebzadehmich.wordpress.com
>
> __
>
> Author of the books*"A Practitioner's Guide to Upgrading to 
> Sybase**ASE 15", **ISBN 978-0-9563693-0-7*.
>
> co-author *"Sybase Transact SQL Guidelines Best Practices", ISBN 
> 978-0-9759693-0-4*
>
> _Publications due shortly:_
>
> *Creating in-memory Data Grid for Trading Systems with Oracle TimesTen 
> and Coherence Cache*
>
> *Oracle and Sybase, Concepts and Contrasts*, ISBN:978-0-9563693-1-4, 
> volume one out shortly
>
> NOTE: The information in this email is proprietary and confidential. 
> This message is for the designated recipient only, if you are not the 
> intended recipient, you should destroy it immediately. Any information 
> in this message shall not be understood as given or endorsed by 
> Peridale Ltd, its subsidiaries or their employees, unless expressly so 
> stated. It is the responsibility of the recipient to ensure that this 
> email is virus free, therefore neither Peridale Ltd, its subsidiaries 
> nor their employees accept any responsibility.
>

Mime
View raw message