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

Improve performance of a Scanner with explicit column list when rows are small/medium size

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 0.98.0, 0.94.12, 0.96.0
    • Fix Version/s: None
    • Component/s: Scanners
    • Labels:
      None
    • Release Note:
      Hide
      The feature allows to improve performance of scan operations when table rows are small/medium size and scan operation contains explicit set of column:qualifiers to filter on. By default, the feature is disabled. To enable it set Scan.HINT_NARROW_ROWS attribute of Scan object instance:
      Scan scan = ...
      scan.setAttribute(Scan.HINT_NARROW_ROWS, Bytes.toBytes(Boolean.TRUE));

      The performance improvement depends on a average row size. The smaller rows are - the larger performance improvement is.
      Show
      The feature allows to improve performance of scan operations when table rows are small/medium size and scan operation contains explicit set of column:qualifiers to filter on. By default, the feature is disabled. To enable it set Scan.HINT_NARROW_ROWS attribute of Scan object instance: Scan scan = ... scan.setAttribute(Scan.HINT_NARROW_ROWS, Bytes.toBytes(Boolean.TRUE)); The performance improvement depends on a average row size. The smaller rows are - the larger performance improvement is.

      Attachments

      1. 9769-0.94-sample.txt
        1 kB
        Lars Hofhansl
      2. 9769-0.94-sample1.txt
        1 kB
        Lars Hofhansl
      3. 9769-0.94-sample2.txt
        0.9 kB
        Lars Hofhansl
      4. 9769-94.txt
        9 kB
        Vladimir Rodionov
      5. 9769-94-v2.txt
        9 kB
        Vladimir Rodionov
      6. 9769-trunk-v1.txt
        8 kB
        Vladimir Rodionov
      7. 9769-trunk-v2.txt
        12 kB
        Vladimir Rodionov
      8. 9769-trunk-v3.txt
        13 kB
        Vladimir Rodionov
      9. 9769-trunk-v4.txt
        12 kB
        Vladimir Rodionov

        Issue Links

          Activity

            People

            • Assignee:
              vrodionov Vladimir Rodionov
              Reporter:
              vrodionov Vladimir Rodionov
            • Votes:
              0 Vote for this issue
              Watchers:
              13 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: