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 D2EB8EF40 for ; Fri, 1 Mar 2013 16:25:14 +0000 (UTC) Received: (qmail 94489 invoked by uid 500); 1 Mar 2013 16:25:14 -0000 Delivered-To: apmail-hbase-issues-archive@hbase.apache.org Received: (qmail 94442 invoked by uid 500); 1 Mar 2013 16:25:14 -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 94433 invoked by uid 99); 1 Mar 2013 16:25:14 -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:25:14 +0000 Date: Fri, 1 Mar 2013 16:25:14 +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: ------------------------------------------ Attachment: HBASE-7928_trunk_2.patch Updated once again as per Anoop's comments. > 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 > Attachments: HBASE-7928_0.94_1.patch, HBASE-7928_0.94_2.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