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

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 0.98.0, 0.94.12, 0.96.0
    • None
    • Scanners
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: