You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "BELUGA BEHR (JIRA)" <ji...@apache.org> on 2017/07/25 14:36:00 UTC

[jira] [Created] (HIVE-17165) Implement Gap Locking

BELUGA BEHR created HIVE-17165:
----------------------------------

             Summary: Implement Gap Locking
                 Key: HIVE-17165
                 URL: https://issues.apache.org/jira/browse/HIVE-17165
             Project: Hive
          Issue Type: Improvement
          Components: HiveServer2
    Affects Versions: 2.1.1, 1.2.2, 3.0.0
            Reporter: BELUGA BEHR
            Priority: Minor


MySQL implements a feature called "gap locks."   This is a single object that locks a range of rows within an index.  This would be helpful for HiveServer2 ZooKeeper locks on partitions.  The current behavior is that a unique lock is created for each and every partition.  This can place a lot of load on the ZooKeeper instances, and many partitions also means many round-trip operations to create each ZNode individually.

https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)