You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hbase.apache.org by "Jean-Marc Spaggiari (JIRA)" <ji...@apache.org> on 2013/02/25 17:00:14 UTC

[jira] [Created] (HBASE-7928) Scanning .META. with startRow and/or stopRow is not giving proper results

Jean-Marc Spaggiari created HBASE-7928:
------------------------------------------

             Summary: 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