Grokbase Groups HBase user June 2016
FAQ
Hi,

As per the official documentation of HBase it is mentioned that HBase typical schema should contain 1 to 3 column families per table (https://hbase.apache.org/book.html#table_schema_rules_of_thumb ) .
However there is no mention of how many column qualifiers should a row contain for each column family to see good read & write performance.
Could anybody let us know their input on how many columns per row is desirable in HBase or how many column qualifiers per column family would be desirable.
Thanks,
Siddharth Ubale,

Search Discussions

  • Saad Mufti at Jun 16, 2016 at 5:00 pm
    There is no real column schema in HBase other than defining the column
    family, each write to a column writes a cell with the column name plus
    value, so in theory number of columns doesn't really matter. What matters
    is how much data you read and write.

    That said there are settings in the column family schema for
    DATA_BLOCK_ENCODING
    that affect how much actual space each column/cell takes, FAST_DIFF is a
    decent choice to make sure there is not too much redundancy by writing the
    same column name over and over again if lots of rows have the same column
    name. There are also compression settings of course.

    Hope that helps.

    ----
    Saad

    On Wed, Jun 15, 2016 at 7:11 AM, Siddharth Ubale wrote:

    Hi,

    As per the official documentation of HBase it is mentioned that HBase
    typical schema should contain 1 to 3 column families per table (
    https://hbase.apache.org/book.html#table_schema_rules_of_thumb ) .
    However there is no mention of how many column qualifiers should a row
    contain for each column family to see good read & write performance.
    Could anybody let us know their input on how many columns per row is
    desirable in HBase or how many column qualifiers per column family would be
    desirable.
    Thanks,
    Siddharth Ubale,

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshbase, hadoop
postedJun 15, '16 at 11:11a
activeJun 16, '16 at 5:00p
posts2
users2
websitehbase.apache.org

2 users in discussion

Siddharth Ubale: 1 post Saad Mufti: 1 post

People

Translate

site design / logo © 2018 Grokbase