You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Guillermo Ortiz <ko...@gmail.com> on 2015/04/08 10:30:19 UTC

Create tables is blocked while there are queries executing in a specific database in Hive

Hi,

I'm working with Hive.
I have many queries executing in a specific database in Hive and I have
tried to created an table in that database.
The creating gets stopped until the queries end. If those queries last 10
hours I couldn't create any table in the next 10 hours, is it normal? It
seems a little weird. Which is the reason?

I have checked that if I disable the parameter  *set
hive.support.concurrency = false; *I could create tables while there're
queries executing but I don't know the consequences that it means do
disable that parameter although I could disable it just for one hive
console..

Could someone explain me a little about all of this?

Re: Create tables is blocked while there are queries executing in a specific database in Hive

Posted by Eugene Koifman <ek...@hortonworks.com>.
Do you have hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager in addition to hive.support.concurrency=true?
if so you may be hitting https://issues.apache.org/jira/browse/HIVE-10242.

From: Guillermo Ortiz <ko...@gmail.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Wednesday, April 8, 2015 at 1:30 AM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Subject: Create tables is blocked while there are queries executing in a specific database in Hive

Hi,

I'm working with Hive.
I have many queries executing in a specific database in Hive and I have tried to created an table in that database.
The creating gets stopped until the queries end. If those queries last 10 hours I couldn't create any table in the next 10 hours, is it normal? It seems a little weird. Which is the reason?

I have checked that if I disable the parameter  set hive.support.concurrency = false; I could create tables while there're queries executing but I don't know the consequences that it means do disable that parameter although I could disable it just for one hive console..

Could someone explain me a little about all of this?