Hbase messaging table structure
I am very new to Hbase.. <br />
I want to create a table, where I would store private messages from one user to another, however, I am unable to come up with table structure.
I was thinking about creating key made of both users IDs and a timestamp, however, this doesn't seem to be correct way to approach this. <br />
Say I have user1 (ID: 1) and user2 (ID: 2) the key will look like "1_2_timestamp" so I will be able to scan only for user1's messages, but not user2..
Is there any way around this without duplicating records?
Hbase messaging table structure
===

I am very new to Hbase.. <br />
I want to create a table, where I would store private messages from one user to another, however, I am unable to come up with table structure.
I was thinking about creating key made of both users IDs and a timestamp, however, this doesn't seem to be correct way to approach this. <br />
Say I have user1 (ID: 1) and user2 (ID: 2) the key will look like "1_2_timestamp" so I will be able to scan only for user1's messages, but not user2..
Is there any way around this without duplicating records?