hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <>
Subject Re: INSERT OVERWRITE partition while SELECT is going on
Date Fri, 03 Apr 2015 20:52:55 GMT
I'm no expert, but I don't think SELECTs are broken by an INSERT.  See
Locking <> for

As I understand it, the INSERT needs an exclusive lock on the partition
which it cannot get while the partition has a shared lock on it.

Can someone confirm or correct this?

-- Lefty

On Fri, Apr 3, 2015 at 4:33 PM, Thomas Kwan <> wrote:

> Hi there,
> If we have multiple SELECTs going on for a table, will doing a "INSERT
> OVERWRITE" to replace a partition break those SELECTs?
> thanks in advance

View raw message