[
https://issues.apache.org/jira/browse/HBASE-7928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13585977#comment-13585977
]
Kevin Odell commented on HBASE-7928:
------------------------------------
hbase(main):003:0> create 'test2', 'cf1', {SPLITS => ['111', '222', '333']}
0 row(s) in 1.1520 seconds
hbase(main):005:0> put 'test2', '111', 'cf1:1', '1111'
0 row(s) in 0.1180 seconds
hbase(main):006:0> put 'test2', '111', 'cf1:1', '1112'
0 row(s) in 0.0080 seconds
hbase(main):007:0> put 'test2', '112', 'cf1:1', '1112'
0 row(s) in 0.0070 seconds
hbase(main):008:0> put 'test2', '113', 'cf1:1', '1112'
0 row(s) in 0.0070 seconds
hbase(main):009:0> put 'test2', '211', 'cf1:1', '1112'
0 row(s) in 0.0070 seconds
hbase(main):010:0> put 'test2', '212', 'cf1:1', '1112'
0 row(s) in 0.0630 seconds
hbase(main):011:0> put 'test2', '213', 'cf1:1', '1112'
0 row(s) in 0.0070 seconds
hbase(main):012:0> put 'test2', '311', 'cf1:1', '1112'
0 row(s) in 0.0150 seconds
hbase(main):013:0> put 'test2', '312', 'cf1:1', '1112'
0 row(s) in 0.0090 seconds
hbase(main):014:0> put 'test2', '313', 'cf1:1', '1112'
0 row(s) in 0.0060 seconds
hbase(main):020:0> scan 'test2', {STARTROW => '1', LIMIT => 2}
ROW COLUMN+CELL
111 column=cf1:1,
timestamp=1361809376535, value=1112
112 column=cf1:1,
timestamp=1361809383138, value=1112
hbase(main):021:0> scan 'test2', {STARTROW => '2', LIMIT => 2}
ROW COLUMN+CELL
211 column=cf1:1,
timestamp=1361809393858, value=1112
212 column=cf1:1,
timestamp=1361809398016, value=1112
hbase(main):029:0> scan '.META.', {STARTROW => '111', LIMIT => 2}
ROW COLUMN+CELL
brian,,1360685707510.81752ad34514d0d73735574fcb5280d column=info:regioninfo,
timestamp=1360685707961, value={NAME =>
'brian,,1360685707510.81752ad34514d0d73735574fcb5280d7.', STARTKEY => '',
ENDKEY => '', ENC
7. ODED =>
81752ad34514d0d73735574fcb5280d7,}
brian,,1360685707510.81752ad34514d0d73735574fcb5280d column=info:server,
timestamp=1360685708115, value=cdh4-hbase-02:60020
7.
brian,,1360685707510.81752ad34514d0d73735574fcb5280d
column=info:serverstartcode, timestamp=1360685708115, value=1357233940879
7.
sent_email_su_lapse1d,,1360634184398.44fee2ed9f35ece column=info:regioninfo,
timestamp=1360634184882, value={NAME =>
'sent_email_su_lapse1d,,1360634184398.44fee2ed9f35ece213df06ac6f69a908.',
STARTKEY => '', E
213df06ac6f69a908.
.META. appears to be ignoring any of the extra flags.
> 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
>
> {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
