hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alan Gates <alanfga...@gmail.com>
Subject Re: Reading tables will lock entire database in Hive 0.13
Date Thu, 26 Feb 2015 04:57:38 GMT
What lock manager are you using?

Alan.

> Jim Green <mailto:openkbinfo@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)

Mime
View raw message