Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2D9DA9137 for ; Mon, 18 Jun 2012 13:15:20 +0000 (UTC) Received: (qmail 64249 invoked by uid 500); 18 Jun 2012 13:15:18 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 64041 invoked by uid 500); 18 Jun 2012 13:15:18 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 63945 invoked by uid 99); 18 Jun 2012 13:15:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Jun 2012 13:15:18 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of anoopsj@huawei.com designates 119.145.14.65 as permitted sender) Received: from [119.145.14.65] (HELO szxga02-in.huawei.com) (119.145.14.65) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Jun 2012 13:15:10 +0000 Received: from 172.24.2.119 (EHLO szxeml214-edg.china.huawei.com) ([172.24.2.119]) by szxrg02-dlp.huawei.com (MOS 4.1.9-GA FastPath queued) with ESMTP id AKN46897; Mon, 18 Jun 2012 21:14:48 +0800 (CST) Received: from SZXEML401-HUB.china.huawei.com (10.82.67.31) by szxeml214-edg.china.huawei.com (172.24.2.29) with Microsoft SMTP Server (TLS) id 14.1.323.3; Mon, 18 Jun 2012 21:11:49 +0800 Received: from SZXEML531-MBX.china.huawei.com ([fe80::61a8:2cb5:62f9:d4a4]) by szxeml401-hub.china.huawei.com ([::1]) with mapi id 14.01.0323.003; Mon, 18 Jun 2012 21:11:51 +0800 From: Anoop Sam John To: "user@hbase.apache.org" Subject: RE: Isolation level Thread-Topic: Isolation level Thread-Index: AQHNSu82GSRudLHyD0KKvcl4+II585b7CdMAgARmFOqAAAQngIAAkjY2 Date: Mon, 18 Jun 2012 13:11:50 +0000 Message-ID: <0CE69E9126D0344088798A3B7F7F8086311332AC@szxeml531-mbx.china.huawei.com> References: , <0CE69E9126D0344088798A3B7F7F80863112ED91@szxeml531-mbx.china.huawei.com>, In-Reply-To: Accept-Language: en-US, zh-CN Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.18.96.95] Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-CFilter-Loop: Reflected X-Virus-Checked: Checked by ClamAV on apache.org Hi A put operation HBase may need to write data to multiple stores. [Depends o= n presence of KVs belonging to different CFs in the Put] A put can be considered as committed when it has successfully done the writ= e to all the corresponding stores [In turn into the Memstores of those stor= es] In case of a READ_UNCOMMITTED level, there can be situation of partial row = read. At the time of read the write was completed in one store but not in a= nother. The read committed level makes sure this will not happen using the MVCC. -Anoop- ________________________________________ From: Michael Segel [michael_segel@hotmail.com] Sent: Monday, June 18, 2012 5:16 PM To: user@hbase.apache.org Subject: Re: Isolation level Since you don't have OLTP, the terms need to be better defined. What is meant by an uncommitted_ write in HBase? RLL in RDBMS is different than RLL in HBase. You don't have the concept of = a transaction in HBase. -Mike On Jun 17, 2012, at 10:32 PM, Anoop Sam John wrote: > Hi > You can check Scan#setIsolationLevel() API for changing the lev= el. By default it is read committed means read only committed writes. > > -Anoop- > ________________________________________ > From: Jerry Lam [chilinglam@gmail.com] > Sent: Friday, June 15, 2012 9:51 PM > To: user@hbase.apache.org > Subject: Re: Isolation level > > Hi Cristina: > > My understanding of HBase is that the isolation level fro read ops is Rea= d > Committed. There is only write lock which could protect the data from > modifying by other requests but there is no read-lock (it is there but it > doesn't have any effect). Since put ops are atomic, it can succeed or fai= l > but not in the middle so clients can only read the data if the write ops > succeeds > > HTH, > > Jerry > > > On Fri, Jun 15, 2012 at 7:59 AM, Cristina wrote: > >> Hi, >> >> I have read that Hbase has read committed as isolation level, but I have >> some >> doubts. >> Is it possible to chage this level, for instance to read uncommitted? Ho= w >> could >> I do this? >> Another question, Is this isolation level based on locks? I have doubts >> because >> Hbase has multiversion concurrency control so it may implement read >> committed >> snapshot or snapshot isolation. >> >> Thanks, >> Cristina >> >>=