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

13 replies
36420 views
Translate All

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

EricLAnswer

Platinum ⭐️⭐️

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

EricLAnswer

Platinum ⭐️⭐️

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

Translate