[ 
https://issues.apache.org/jira/browse/HIVE-1293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12897977#action_12897977
 ] 

John Sichi commented on HIVE-1293:
----------------------------------

Namit, I tried testing with a standalone zookeeper via CLI.  Locking a table 
succeeded, but then show locks didn't show anything, and unlock said the lock 
didn't exist.

I think the reason is that CLI is creating a new Driver for each statement 
executed, and when the old Driver is closed, the lock manager is closed along 
with it (closing the ZooKeeper client instance).  As a result, locks are 
released immediately after LOCK TABLE is executed.

When I tested with a thrift server plus two JDBC clients, all was well.  I was 
able to take a lock from one client and prevent the other client from getting 
the same lock.  So I guess the thrift server is keeping one Driver around per 
connection.


> Concurreny Model for Hive
> -------------------------
>
>                 Key: HIVE-1293
>                 URL: https://issues.apache.org/jira/browse/HIVE-1293
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>             Fix For: 0.7.0
>
>         Attachments: hive.1293.1.patch, hive.1293.2.patch, hive.1293.3.patch, 
> hive.1293.4.patch, hive.1293.5.patch, hive_leases.txt
>
>
> Concurrency model for Hive:
> Currently, hive does not provide a good concurrency model. The only 
> guanrantee provided in case of concurrent readers and writers is that
> reader will not see partial data from the old version (before the write) and 
> partial data from the new version (after the write).
> This has come across as a big problem, specially for background processes 
> performing maintenance operations.
> The following possible solutions come to mind.
> 1. Locks: Acquire read/write locks - they can be acquired at the beginning of 
> the query or the write locks can be delayed till move
> task (when the directory is actually moved). Care needs to be taken for 
> deadlocks.
> 2. Versioning: The writer can create a new version if the current version is 
> being read. Note that, it is not equivalent to snapshots,
> the old version can only be accessed by the current readers, and will be 
> deleted when all of them have finished.
> Comments.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to