1 question.
user_cook_id, user_facebook_id, user_cell_phone, user_personal_id :
Combination key of all will be unique? Or all of them are unique
individually.?
If a combination can be unique then a having extra column(index enabled)
per row should work for you.
-Vivek
On Thu, Sep 27, 2012 at 7:22 PM, Andre Tavares <andre...@gmail.com> wrote:
>
> Hi community,
>
> I have a question: I need to do a search on a CF that has over 200 million
> rows to find an User key.
>
> To find the user, I have 4 keys (acctualy I have 4 keys but it that can
> increase) that are: user_cook_id, user_facebook_id, user_cell_phone,
> user_personal_id
>
> If I don't find the User by the informed key I need perform another query
> passing the others existing keys to find the user.
>
> My doubt:What is the better design to mine CF to find the user over the 4
> keys? I thought to create an CF with secondary index like this:
>
> create column family users_test with comparator=UTF8Type and
> column_metadata=[
> {column_name: user_cook_id, validation_class: UTF8Type, index_type: KEYS},
> {column_name: user_facebook_id, validation_class: UTF8Type, index_type:
> KEYS},
> {column_name: user_cell_phone, validation_class: UTF8Type, index_type:
> KEYS},
> {column_name: user_personal_id, validation_class: UTF8Type, index_type:
> KEYS},
> {column_name: user_key, validation_class: UTF8Type, index_type: KEYS}
> ];
>
> Another approaching is creating just one column for the User CF having
> generic KEY
>
> create column family users_test with comparator=UTF8Type and
> column_metadata=[
> {column_name: generic_key, validation_class: UTF8Type, index_type: KEYS},
> {column_name: user_key, validation_class: UTF8Type, index_type: KEYS}
> ];
>
> where generic_id can be: user_cook_id value, or a user_facebook_id,
> user_cell_phone, user_personal_id values ... the "problem" of this solution
> is that I have 200 million users_id x 4 keys (user_cook_id,
> user_facebook_id, user_cell_phone, user_personal_id) = 800 million rows
>
> I ask to my friends if am I on the right way or suggestions are well come
> .. thanks
>
