Hi all, iam new user of Hbase and i need help with secondary indexes.
For example i have messages and users. Each user has many messages. Data structure will be like this: Message: - String id - Long sender_id - Long recipient_id - String text - Timestamp created_at [...] User: - Long id - String username [...] I need create secondary indexes for reading all messages: a) inbox (by recipient_id) in timerange. b) outbox (by sender_id) in timerange Can someone give me suggestions for this index(es) and attributes for columnFamily? I expect here 500M messages and 50M users. Thanks a lot for response. P.S. Sorry for my bad english, isn't my primary language Lukas Drbal
