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

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

It seems it's only impacting .META. (and maybe a bit -ROOT- too...)

{code}
    try {
      HTable metaTable = new HTable(config, Bytes.toBytes("-ROOT-"));
      Scan scan = new Scan();
      scan.setStartRow(new byte[]{0});
      //scan.setStopRow(new byte[]{127});
      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 is working for for ROOT, but not if I setup the stoprow.
                
> 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
>
> {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