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,670 points
1,560 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,390 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,390 points
1,268 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,390 points
456 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,390 points
6,268 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,390 points
1,055 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,390 points
562 views
0 votes
1 answer

Key Components of HBase

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

answered Jul 24, 2018 in Database by kurt_cobain
• 9,390 points
1,346 views
0 votes
1 answer

Delete row in HBase

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

answered Jul 24, 2018 in Database by kurt_cobain
• 9,390 points
1,538 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,390 points
464 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,390 points
3,548 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP