Put table in a table

Question

I have a schema design that looks like this:

Table: User
    Row                Column Family
                       User
    u1                 User:name
                       User:mail

                       Table: Tags
                       Row                  Column
                       t1                   tag_id

So, it's a table in a table. My question is, how do I add a table in a table by using the HBase shell? I know the 'put' command to add values to a column in a specific column family. But, it gives me not the ability to add a table in a table. Does anyone know how to do this?

Thanks, Leander

Update 25 june,

Thanks Tariq! I fixed it this way (inspired by your answer)

Table: User
u1                    User:name
                      User:mail
                      User:tags = ['t1', 't2', 't4']

Table: Tags
t1                    Tag:tag_id
                      Tag:users = ['u1', 'u2']

score 0 · Accepted Answer · answered Jun 21 '12 at 22:02

0

This is not possible. However you can design your schema wisely to fit it into your requirements. For example, create a table "user" just like you have shown..Then create one more table called "Tags" with a single column family "tag_id"..Make he row keys for the "User" table just like you have specified above and for the "Tags" table create row keys by suffixing "t1" to "u1" so that all the tags by a particular user will go to the same row..So your keys will look somewhat like this "abc+t1"..This will help you to fetch the tags by a particular user efficiently..Please let me know if you find it appropriate for your use-case.

answered Jun 21 '12 at 22:02

Tariq

34,076
8
57
79

Thanks! I edited my post inspired by you (Not really your solution but I think that this one fits better in my whole design). I could search now by tag and user (which tags has a specific user and which users has a specific tag). Correct me if I'm wrong. – Leander Jun 25 '12 at 07:45
You are always welcome Leander..and it feels good to hear that my suggestion helped you in designing your schema..and you are right..you can do that..but I would like to know one thing here (just out of curiosity), why do you need 2 tables..I mean if you want to fetch all the users having a particular tag you can always use "QualifierFilter" for that. – Tariq Jun 25 '12 at 08:21
Because I have an another table which is called Questions. That table is also connected with the tags table. So I think that I get more profit with this approach for both tables. – Leander Jun 26 '12 at 11:38

Put table in a table

1 Answers1