Re: Delete hive partition while executing query.

Wednesday, June 8, 2016 at 7:30 AM > To: "user@hive.apache.org" > Subject: Re: Delete hive partition while executing query. > > Hi, thanks for reply, Alan. > Here's one more test. > > Wed Jun 08 16:36:02 MSK 2016 Start thread 1 > Wed Jun 08 16:36:05 MSK 2016 St

Re: Delete hive partition while executing query.

quot; mailto:user@hive.apache.org>> Subject: Re: Delete hive partition while executing query. Hi, thanks for reply, Alan. Here's one more test. Wed Jun 08 16:36:02 MSK 2016 Start thread 1 Wed Jun 08 16:36:05 MSK 2016 Start thread 2 Wed Jun 08 16:36:08 MSK 2016 Start thread 3 Wed Jun 08 1

Re: Delete hive partition while executing query.

Hi, thanks for reply, Alan. Here's one more test. Wed Jun 08 16:36:02 MSK 2016 Start thread 1 Wed Jun 08 16:36:05 MSK 2016 Start thread 2 Wed Jun 08 16:36:08 MSK 2016 Start thread 3 Wed Jun 08 16:36:11 MSK 2016 Start thread 4 Wed Jun 08 16:36:17 MSK 2016 Finish thread 1 Wed Jun 08 16:36:17 MSK 201

Re: Delete hive partition while executing query.

Eugene Koifman pointed out to me that there is one other possibility. If we ignore query 3 for a minute, I can explain this with the following timeline: 1) Query one requests and gets a read lock, starts its select. 2) Query two (alter table…) requests an exclusive lock, and then blocks until q

Re: Delete hive partition while executing query.

- hive.support.concurrency – true - hive.enforce.bucketing

Re: Delete hive partition while executing query.

Do you have the system configured to use the DbTxnManager? See https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Configuration for details on how to set this up. The transaction manager is what manages locking and makes sure that your queries don’t stomp each