Return-Path: X-Original-To: apmail-hbase-issues-archive@www.apache.org Delivered-To: apmail-hbase-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id B2FA69B03 for ; Fri, 1 Mar 2013 16:43:13 +0000 (UTC) Received: (qmail 64512 invoked by uid 500); 1 Mar 2013 16:43:13 -0000 Delivered-To: apmail-hbase-issues-archive@hbase.apache.org Received: (qmail 64363 invoked by uid 500); 1 Mar 2013 16:43:13 -0000 Mailing-List: contact issues-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list issues@hbase.apache.org Received: (qmail 64354 invoked by uid 99); 1 Mar 2013 16:43:13 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Mar 2013 16:43:13 +0000 Date: Fri, 1 Mar 2013 16:43:13 +0000 (UTC) From: "ramkrishna.s.vasudevan (JIRA)" To: issues@hbase.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (HBASE-7928) Scanning .META. with startRow and/or stopRow is not giving proper results MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HBASE-7928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ramkrishna.s.vasudevan updated HBASE-7928: ------------------------------------------ Resolution: Fixed Fix Version/s: 0.94.6 0.98.0 0.95.0 Hadoop Flags: Reviewed Status: Resolved (was: Patch Available) Committed to all three branches. Thanks to Anoop, Ted and Stack for the review. Thanks to Jean for verifying the patch. > Scanning .META. with startRow and/or stopRow is not giving proper results > ------------------------------------------------------------------------- > > Key: HBASE-7928 > URL: https://issues.apache.org/jira/browse/HBASE-7928 > Project: HBase > Issue Type: Bug > Components: Usability > Affects Versions: 0.94.5 > Reporter: Jean-Marc Spaggiari > Assignee: ramkrishna.s.vasudevan > Fix For: 0.95.0, 0.98.0, 0.94.6 > > Attachments: HBASE-7928_0.94_1.patch, HBASE-7928_0.94_2.patch, HBASE-7928_0.94_3.patch, HBASE-7928_0.94_3.patch, HBASE-7928_0.94.patch, HBASE-7928_trunk_1.patch, HBASE-7928_trunk_2.patch, HBASE-7928_trunk_2.patch, HBASE-7928_trunk.patch > > > {code} > try { > HTable metaTable = new HTable(config, Bytes.toBytes(".META.")); > Scan scan = new Scan(); > scan.setStartRow(Bytes.toBytes("e")); > scan.setStopRow(Bytes.toBytes("z")); > ResultScanner scanner = metaTable.getScanner(scan); > Result[] results = scanner.next(100); > while (results.length > 0) { > for (Result result : results) { > System.out.println(Bytes.toString(result.getRow())); > } > results = scanner.next(100); > } > scanner.close(); > metaTable.close(); > } catch (Exception e) { > e.printStackTrace(); > } > {code} > This code will not return any result even if there is 10 tables with names starting with "d" to "w", including one table called "entry". If you comment the setStopRow you will get results, but will still get rows starting with "d" even if setStartRow is set to "e". > Same code using with a user table is working fine. > Facing the same issue with the shell. > scan '.META.' , {STARTROW => 'e', LIMIT => 10} is returning rows starting by "d". > scan '.META.' , {STARTROW => 'e', STOPROW => 'v', LIMIT => 10} is not returning anything. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira