Return-Path: X-Original-To: apmail-hbase-dev-archive@www.apache.org Delivered-To: apmail-hbase-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C47C97B03 for ; Mon, 18 Jul 2011 06:23:29 +0000 (UTC) Received: (qmail 19005 invoked by uid 500); 18 Jul 2011 06:23:25 -0000 Delivered-To: apmail-hbase-dev-archive@hbase.apache.org Received: (qmail 18271 invoked by uid 500); 18 Jul 2011 06:23:12 -0000 Mailing-List: contact dev-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hbase.apache.org Delivered-To: mailing list dev@hbase.apache.org Received: (qmail 18233 invoked by uid 99); 18 Jul 2011 06:23:01 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Jul 2011 06:23:01 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of lars.george@gmail.com designates 209.85.214.169 as permitted sender) Received: from [209.85.214.169] (HELO mail-iw0-f169.google.com) (209.85.214.169) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Jul 2011 06:22:53 +0000 Received: by iwn8 with SMTP id 8so3500808iwn.14 for ; Sun, 17 Jul 2011 23:22:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=content-type:mime-version:subject:from:in-reply-to:date :content-transfer-encoding:message-id:references:to:x-mailer; bh=TN25Z/CbGUa8gSoA7XNgznkINzNfv2EJT3eEWnm9ZSQ=; b=Yf0CJxRoW31dToFPqiPB08q6qkkeus7VVDKbIlXq5mdJKirzNaFskyLOlAG5Dpk+66 tr04OjADb9DTPf36W1N3xYiGEiemns/fQYHZT7v6beTckbeXCY2wFt7EbGZbkylq6Rud d3L3fIjY8Ni4Q35gIpd26xv24D1RxiR0tGkhY= Received: by 10.43.59.142 with SMTP id wo14mr6811333icb.373.1310970151718; Sun, 17 Jul 2011 23:22:31 -0700 (PDT) Received: from [10.0.0.64] (p4FCF3687.dip.t-dialin.net [79.207.54.135]) by mx.google.com with ESMTPS id o1sm4574820ict.20.2011.07.17.23.22.27 (version=TLSv1/SSLv3 cipher=OTHER); Sun, 17 Jul 2011 23:22:28 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Apple Message framework v1084) Subject: Re: Scanning .META. with start/stop row From: Lars George In-Reply-To: Date: Mon, 18 Jul 2011 08:22:24 +0200 Content-Transfer-Encoding: quoted-printable Message-Id: References: To: dev@hbase.apache.org X-Mailer: Apple Mail (2.1084) X-Virus-Checked: Checked by ClamAV on apache.org Wow, awesome Todd: hbase(main):004:0> scan '.META.', {STARTROW =3D> 'testtable2', LIMIT =3D> = 1} ROW COLUMN+CELL = =20 2011-07-17T23:20:45.480-0700: 58.760: [GC 58.760: [ParNew: = 19136K->2112K(19136K), 0.0098980 secs] 21990K->6759K(83008K), 0.0099430 = secs] [Times: user=3D0.05 sys=3D0.00, real=3D0.01 secs]=20 TestTable,,1294648777729.1c1644f4a column=3Dinfo:regioninfo, = timestamp=3D1294648777898, value=3DREGION =3D> {NAME =3D> = 'TestTable,,1294648777729.1c 1304442d9c8483a6d167d48. 1644f4a1304442d9c8483a6d167d48.', = STARTKEY =3D> '', ENDKEY =3D> '', ENCODED =3D> = 1c1644f4a1304442d9c8483a6d1 67d48, TABLE =3D> {{NAME =3D> = 'TestTable', FAMILIES =3D> [{NAME =3D> 'col1', BLOOMFILTER =3D> 'NONE', = REPLICATIO N_SCOPE =3D> '0', COMPRESSION =3D> = 'NONE', VERSIONS =3D> '3', TTL =3D> '2147483647', BLOCKSIZE =3D> = '65536', IN_ MEMORY =3D> 'false', BLOCKCACHE =3D> = 'true'}]}} =20 ... 1 row(s) in 0.3990 seconds hbase(main):005:0> scan '.META.', {STARTROW =3D> 'testtable2,,', LIMIT = =3D> 1} ROW COLUMN+CELL = =20 testtable2,,1310754563673.d720f2ae column=3Dinfo:regioninfo, = timestamp=3D1310754573539, value=3DREGION =3D> {NAME =3D> = 'testtable2,,1310754563673.d 6a4aec4fce746f6a9c1376e3. 720f2ae6a4aec4fce746f6a9c1376e3.', = STARTKEY =3D> '', ENDKEY =3D> 'row-10', ENCODED =3D> = d720f2ae6a4aec4fce74 6f6a9c1376e3, TABLE =3D> {{NAME =3D> = 'testtable2', FAMILIES =3D> [{NAME =3D> 'family', BLOOMFILTER =3D> = 'NONE',=20 REPLICATION_SCOPE =3D> '0', = COMPRESSION =3D> 'NONE', VERSIONS =3D> '3', TTL =3D> '2147483647', = BLOCKSIZE =3D> '6 5536', IN_MEMORY =3D> 'false', = BLOCKCACHE =3D> 'true'}]}} = =20 ... 1 row(s) in 0.0440 seconds This also makes the STOPROW work: hbase(main):006:0> scan '.META.', {STARTROW =3D> 'testtable2,,', STOPROW = =3D> 'testtable3'} ROW COLUMN+CELL = =20 0 row(s) in 0.0220 seconds hbase(main):007:0> scan '.META.', {STARTROW =3D> 'testtable2,,', STOPROW = =3D> 'testtable3,,'} ROW COLUMN+CELL = =20 testtable2,,1310754563673.d720f2ae column=3Dinfo:regioninfo, = timestamp=3D1310754573539, value=3DREGION =3D> {NAME =3D> = 'testtable2,,1310754563673.d 6a4aec4fce746f6a9c1376e3. 720f2ae6a4aec4fce746f6a9c1376e3.', = STARTKEY =3D> '', ENDKEY =3D> 'row-10', ENCODED =3D> = d720f2ae6a4aec4fce74 6f6a9c1376e3, TABLE =3D> {{NAME =3D> = 'testtable2', FAMILIES =3D> [{NAME =3D> 'family', BLOOMFILTER =3D> = 'NONE',=20 REPLICATION_SCOPE =3D> '0', = COMPRESSION =3D> 'NONE', VERSIONS =3D> '3', TTL =3D> '2147483647', = BLOCKSIZE =3D> '6 5536', IN_MEMORY =3D> 'false', = BLOCKCACHE =3D> 'true'}]}} = =20 ... testtable2,row-10,1310754563677.81 column=3Dinfo:regioninfo, = timestamp=3D1310754573667, value=3DREGION =3D> {NAME =3D> = 'testtable2,row-10,131075456 73e0623a0f82c5b308790737900b60. = 3677.8173e0623a0f82c5b308790737900b60.', STARTKEY =3D> 'row-10', ENDKEY = =3D> 'row-20', ENCODED =3D> 8173e062 3a0f82c5b308790737900b60, TABLE =3D> = {{NAME =3D> 'testtable2', FAMILIES =3D> [{NAME =3D> 'family', = BLOOMFILTER =3D> 'NONE', REPLICATION_SCOPE =3D> = '0', COMPRESSION =3D> 'NONE', VERSIONS =3D> '3', TTL =3D> '2147483647', = BLO CKSIZE =3D> '65536', IN_MEMORY =3D> = 'false', BLOCKCACHE =3D> 'true'}]}} =20= ... So it is caused by the same issue. Should be fixed, right? Lars On Jul 18, 2011, at 4:36 AM, Todd Lipcon wrote: > Try with STARTROW =3D> "testtable2,,"? > I seem to remember some weirdness about the start/stop row having to = have > the meta "format" with commas, etc >=20 > -Todd >=20 > On Fri, Jul 15, 2011 at 2:01 PM, Stack wrote: >=20 >> On Fri, Jul 15, 2011 at 11:40 AM, Lars George >> wrote: >>> Using the start row, it prints the entire META. >>=20 >> Starting with the STARTROW. >>=20 >>> Setting a stop row it does >>> not print a single row: >>=20 >>=20 >> Yeah. I see that too in 0.90.3. >>=20 >> St.Ack >>=20 >>>=20 >>> hbase(main):003:0> scan '.META.', { STARTROW =3D> 'testtable2', = STOPROW =3D> >>> 'testtable3' } >>> ROW COLUMN+CELL >>>=20 >>> 0 row(s) in 0.0220 seconds >>>=20 >>> I have a testtable2 in this case. Am I stuffing up the syntax? >>>=20 >>> Lars >>>=20 >>> On Fri, Jul 15, 2011 at 8:36 PM, Stack wrote: >>>=20 >>>> Passing 'STARTROW' in 0.90.3 seems to work. What you see Lars? >>>> St.Ack >>>>=20 >>>> On Fri, Jul 15, 2011 at 11:31 AM, Lars George = >>>> wrote: >>>>> Hi, >>>>>=20 >>>>> I am on 0.90.1 (CDH3u0) but noticed that on trunk as well: doing = scan >> of >>>>> .META. using a start and stop row does not work. The start row = does >>>> nothing, >>>>> i.e. all is shown, and setting the stop row is the opposite, i.e. >> nothing >>>> is >>>>> shown. Is that borked? >>>>>=20 >>>>> Lars >>>>>=20 >>>>=20 >>>=20 >>=20 >=20 >=20 >=20 > --=20 > Todd Lipcon > Software Engineer, Cloudera