Scanning half a key or value in HBase

[Michelan Arendse]

Hi

I am not sure if this is possible in HBase. What I am trying to do is scan on a 
HBase table with something similar to how SQL would do it.
e.g. SELECT *
         FROM <table>
         WHERE <primary key> LIKE '<first_half_of_key>%' ;

So as you can see from above I want to scan the table with only part of the row 
key, since the key is a combination of 2 fields in the table.

Regards,
Michelan Arendse