Locks in Hive

hive>show locks; 
mysql> select hl_lock_ext_id from HIVE_LOCKS where HL_TABLE=’prcs_task’;
delete from hive_locks where hl_lock_ext_id = 125542 
delete from hive_locks where hl_lock_ext_id = 127397
delete from hive_locks where hl_lock_ext_id = 127399
delete from hive_locks where hl_lock_ext_id = 127405

--

--

--

Support Engineer @DataRobot

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

The Ultimate Single-Page App for Developers and IT Pros: Your Terminal.

Scala Style, using immutable over mutable — Post 2

Custom Notifications for Android

Reactive Programming in Flutter: State Management with MobX

Hi Guys,

A sad truth about software engineering

GCP Solving MySQL HA Replication Lag

What is OOP? In Layman terms…

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Tamil Selvan K

Tamil Selvan K

Support Engineer @DataRobot

More from Medium

Python: How to Convert Database(Tables) to XLSX Workbooks

Dealing With Exam Stress And Anxiety

a computer screen showing a statistic about exam stress and anxiety

Hadoop Developer- Roles and Responsibilities

Data Types in JVM

Data Types in JVM