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?