Table design approach Hbase

0 votes
What is the various table design approach for any Hbase Table?
Jul 10, 2018 in Database by shams
• 3,580 points
236 views

1 answer to this question.

0 votes
Tall-Narrow and Flat-Wide are the two HBase table design approaches that can be used. However, which approach should be used when merely depends on what you want to achieve and how you want to use the data. The performance of HBase completely depends on the RowKey and hence on directly on how data is accessed.

On a high level, the major difference between flat-wide and tall-narrow approach is similar to the difference between get and scan. Full scans are costly in HBase because of ordered RowKey storage policy. Tall-narrow approach can be used when there is a complex RowKey so that focused scans can be performed on a logical group of entries.

Ideally, the tall-narrow approach is used when there are less number of rows and a large number of columns whereas flat-wide approach is used when there are less number of columns and a large number of rows.

Hope this helps
answered Jul 10, 2018 by Data_Nerd
• 2,360 points

Related Questions In Database

0 votes
1 answer

Standalone Mode in Hbase

It is a default mode of HBase. ...READ MORE

answered Jul 11, 2018 in Database by kurt_cobain
• 9,240 points
45 views
0 votes
1 answer

Compaction HBase

Compaction is a process which is used ...READ MORE

answered Jul 31, 2018 in Database by kurt_cobain
• 9,240 points
49 views
0 votes
1 answer

Filters in HBase

ColumnPrefixFilter: takes a single argument, a column ...READ MORE

answered Jul 31, 2018 in Database by kurt_cobain
• 9,240 points
642 views
0 votes
1 answer

Thrift in Hbase

Apache Thrift is written in C++ but ...READ MORE

answered Aug 9, 2018 in Database by kurt_cobain
• 9,240 points
46 views
0 votes
1 answer

What is MSLAB and LZO?

MSLAB stands for Memstore-Local Allocation Buffer. Lempel-Ziv-Oberhumer (LZO) ...READ MORE

answered Jul 10, 2018 in Database by Data_Nerd
• 2,360 points
91 views
0 votes
1 answer

Data model operations in Hbase

1. Get(returns attributes for a specified row, Gets ...READ MORE

answered Jul 16, 2018 in Database by Data_Nerd
• 2,360 points
31 views
0 votes
1 answer

Key Components of HBase

Zookeeper: It does the co-ordination work between client ...READ MORE

answered Jul 23, 2018 in Database by kurt_cobain
• 9,240 points
74 views
0 votes
1 answer

Delete row in HBase

In Hbase, whatever you write will be ...READ MORE

answered Jul 23, 2018 in Database by kurt_cobain
• 9,240 points
187 views
0 votes
1 answer

Connection in Hbase

Following code is used to open a ...READ MORE

answered Jul 11, 2018 in Database by Data_Nerd
• 2,360 points
49 views
0 votes
1 answer

HLog and WAL in Hbase.

All edits in the HStore are stored ...READ MORE

answered Jul 16, 2018 in Database by Data_Nerd
• 2,360 points
466 views