Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Contributor

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 SOLUTIONS

avatar
Super 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

avatar
Contributor

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

View solution in original post

13 REPLIES 13

avatar
Guru

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

avatar
Community Manager

@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?



Regards,

Vidya Sargur,
Community Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community:

avatar
Contributor

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

avatar
Community Manager

Thanks for the confirmation @syedshakir. Much appreciated. 



Regards,

Vidya Sargur,
Community Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community: