Support Questions
Find answers, ask questions, and share your expertise

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
Highlighted

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

View solution in original post

3 REPLIES 3
Highlighted

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

View solution in original post

Highlighted

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

Explorer

Hi ,

 

im facing same issue , 

attached is the error screenshot


atomic error.jpg
Highlighted

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

New Contributor

I am facing the same error when executing sql query through hue server。Now I have no idea to solve the error。 

 

Please。

Don't have an account?