Uploaded image for project: 'HBase'
  1. HBase
  2. HBASE-13721

Improve shell scan performances when using LIMIT

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.1.0
    • Fix Version/s: 0.98.13, 1.0.2, 1.2.0, 1.1.1, 2.0.0
    • Component/s: shell
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      When doing a scan which is expected to return the exact same number of rows as the LIMIT we give, we still scan the entire table until we return the row(s) and then test the numbers of rows we have. This can take a lot of time.

      Example:
      scan 'sensors',

      { COLUMNS => ['v:f92acb5b-079a-42bc-913a-657f270a3dc1'], STARTROW => '000a', LIMIT => 1 }

      This is because we will break on the limit condition AFTER we ask for the next row. If there is none, we scan the entire table than exit.

      Goal of this patch is to handle this specific case without impacting the others.

        Attachments

        1. HBASE-13721-v0-trunk.txt
          2 kB
          Jean-Marc Spaggiari

          Activity

            People

            • Assignee:
              jmspaggi Jean-Marc Spaggiari
              Reporter:
              jmspaggi Jean-Marc Spaggiari
            • Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: