hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <leftylever...@gmail.com>
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 <https://cwiki.apache.org/confluence/display/Hive/Locking> for
details.

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 <thomas.kwan@manage.com> 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
>
>

Mime
View raw message