CODEWITHSUNDEEP
hbase
501 - not implemented
501 - not implemented

Reputation: 2688

HBase performance - get al rows with specific column

can someone explain how good is the performance when I want to get all rows that contains the column with a specific value? Is this a linear search?

thank you

Upvotes: 1

Views: 116

Answers (1)

Alexander Kuznetsov
Alexander Kuznetsov

Reputation: 3112

Yes this a linear search, to find all rows with certain column, you need scan each row in table. The common solution in this case a creation of additional index table. In this table row keys will be column names from data table. Each column in row in this table will be reference to row from main table wich contains a specific column. E.g.

You table 

| Row   | Column     |      
| RA    | CA         |
        | CB         |
        | CC         |
| RB    | CA         |
        | CC         |

Index table 

| Row   | Column     | 
| CA    | RA         |
        | RB         |
| CB    | RA         |
| CC    | RA         |
        | RB         |

Upvotes: 2

Related Questions