[ 
https://issues.apache.org/jira/browse/HBASE-7928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13587199#comment-13587199
 ] 

Jean-Marc Spaggiari commented on HBASE-7928:
--------------------------------------------

Not working, but should be I think.

hbase(main):178:0> scan '.META.', {STARTROW => 'e,,', STOPROW => 
'e,,99999999999999'}
ROW                                                                   
COLUMN+CELL                                                                     
                                                                                
                                        
0 row(s) in 0.0040 seconds

                
> 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

Reply via email to