[
https://issues.apache.org/jira/browse/HBASE-7928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13587237#comment-13587237
]
Jean-Marc Spaggiari commented on HBASE-7928:
--------------------------------------------
scan '.META.', {STARTROW => 'e', STOPROW => 'f'}
27 row(s) in 0.4560 seconds
Like a charm!
scan '.META.', {STARTROW => 'e', STOPROW => 'ez'}
Working too.
Also working fine with Java Client.
{code}
try {
HTable metaTable = new HTable(config, Bytes.toBytes(".META."));
Scan scan = new Scan();
scan.setStartRow(Bytes.toBytes("e"));
scan.setStopRow(Bytes.toBytes("f"));
ResultScanner scanner = metaTable.getScanner(scan);
Result[] results = scanner.next(100);
int regionsCount = 0;
while (results.length > 0) {
for (Result result : results) {
System.out.println(Bytes.toString(result.getRow()));
regionsCount++;
}
results = scanner.next(100);
}
scanner.close();
metaTable.close();
System.out.println (regionsCount);
} catch (Throwable throwable) {
throwable.printStackTrace();
}
{code}
Is giving me 27 too.
+1 for me. Thanks Ramkrishna for the fix!
> 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
> Affects Versions: 0.94.5
> Reporter: Jean-Marc Spaggiari
> Assignee: ramkrishna.s.vasudevan
> Attachments: HBASE-7928_0.94.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
