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

[#1]

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

[#2 · Accepted solution]

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

[#3]

Is hive generating slow response? Is the query slow??

[#4]

@syedshakir, Has any of the replies helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  If you are still experiencing the issue, can you provide the information @asish  has requested?

[#5 · Accepted solution]

Hi,

Issue resolved by increasing number of conection and session timeout as a workaround.

Actually need to use dedicated disk for  DB's.

Thanks,

Syed

[#6]

Thanks for the confirmation @syedshakir. Much appreciated.