Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

You can't execute queries until the end of the 'atomic' block

Solved Go to solution
Highlighted

You can't execute queries until the end of the 'atomic' block

Explorer

Hi,

I am getting above error from Hive while trying to query a table.

This is coincidentally during an insert operation on the table...

 

does it mean I cant access the table while a hive insert operation is ongoing...?

 

table contains lots of rows partitioned by two columns

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: You can't execute queries until the end of the 'atomic' block

Guru
Hi,

I don't see any errors posted in the post, can you please share again?

In general, Hive have locking mechanism enabled, so when INSERT is happening on a table, an exclusive lock will be place on the table and any query tries to run against the same table will have to wait, and there is a timeout to control how long the wait will be, and the query will fail with error if timeout exceeded, otherwise it will just keep waiting until lock is released.

So to understand more on the issue, I need to see what error was reported.

Cheers
Eric
1 REPLY 1

Re: You can't execute queries until the end of the 'atomic' block

Guru
Hi,

I don't see any errors posted in the post, can you please share again?

In general, Hive have locking mechanism enabled, so when INSERT is happening on a table, an exclusive lock will be place on the table and any query tries to run against the same table will have to wait, and there is a timeout to control how long the wait will be, and the query will fail with error if timeout exceeded, otherwise it will just keep waiting until lock is released.

So to understand more on the issue, I need to see what error was reported.

Cheers
Eric
Don't have an account?
Coming from Hortonworks? Activate your account here