We all know how data is stored in any RDBMS table. It looks like this:
ID |
Column_1 |
Column_2 |
Column_3 |
Column_4 |
1 |
A |
11 |
P |
XX |
2 |
B |
12 |
Q |
YY |
3 |
C |
13 |
R |
ZZ |
4 |
D |
14 |
S |
XX1 |
The column ID is used as a unique/primary key of the table to access data from other columns of the table. But in a column-oriented data store like HBase, the same table is divided into key and value and is stored like this:
Key | Value | |
Row | Column | Column Value |
1 | Column_1 | A |
1 | Column_2 | 11 |
1 | Column_3 | P |
1 | Column_4 | XX |
2 | Column_1 | B |
2 | Column_2 | 12 |
2 | Column_3 | Q |
2 | Column_4 | YY |
3 | Column_1 | C |
3 | Column_2 | 13 |
3 | Column_3 | R |
3 | Column_4 | ZZ |
In HBase, ...