Reply
Expert Contributor
Posts: 109
Registered: ‎05-19-2016

check if locks exist on a table in a query

I have

INSERT OVERWRITE

statements scheduled as hive queries through oozie. Before running INSERT OVERWRITE, I want to check if locks exist on the table

i.e something like show locks dbname.tablename

but it should basically return somethign that I can use to decide if I have to run UNLOCK TABLE dbname.tblname or not.

OR

Do we have somethign like UNLOCK TABLE IF EXISTS LOCK dbname.tblname?

It is really important as I have been tryign to find a way to update my tables in hive at the scheduled time but oozie gets stuck if a user was using select on the table and my scheduled queries tried to run right at the same time. I want to make sure that the query runs at its scheduled time even if the select may or may not give the updated results

Cloudera Employee
Posts: 577
Registered: ‎03-23-2015

Re: check if locks exist on a table in a query

IF EXISTS does not work for UNLOCK TABLE query, it is basically not supported. You would better to use Oozie to capture the output of your UNLOCK query and do decision based on that.

Highlighted
Expert Contributor
Posts: 109
Registered: ‎05-19-2016

Re: check if locks exist on a table in a query

Exactly. How do I do it ?

#8t#- Please type your reply above this line -##
Announcements