What lock manager are you using?
Alan.
Jim Green <mailto:openkbi...@gmail.com>
February 25, 2015 at 17:24
Hi Team,
Here is old thread about this issue:
http://qnalist.com/questions/5091386/doubt-about-locking-mechanism-in-hive
I met the same issue that when reading one table in session A, we can
not create a table in the same database in session B. Basically it
causes database level lock in Hive 0.13
when hive.support.concurrency=true.
Minimum reproduce:
--Session A:
create table passwords (col0 string, col1 string, col2 string, col3
string, col4 string,
col5 string, col6 string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ":";
load data local inpath "/etc/passwd" into table passwords;
select count(*) from passwords a,passwords b, passwords c, passwords d
where a.col0=b.col0
and a.col0=c.col0
and a.col0=d.col0;
--Session B:
hive> create table test(id int);
conflicting lock present for default mode EXCLUSIVE
*_/Is this fixed or any jira related?/_*
--
Thanks,
www.openkb.info <http://www.openkb.info>
(Open KnowledgeBase for Hadoop/Database/OS/Network/Tool)