ColumnFamily Design

(5 posts) (2 voices)

• Started 11 months ago by ryoudelman
• Latest reply from ryoudelman
• This topic is not a support question

Tags:

No tags yet.

1. 

   ryoudelman
   Member

   I am looking for some guidance on the best way to design a column family to lookup users given the following constraints:

   Last Name and First Name with on 3 characters of each being required

   Any guidance is appreciated.

   Posted 11 months ago #
2. 

   xedin
   Member

   You can do a custom validation class for your columns which extends AbstractType or do a 3 char validation in your app instead. Put secondary index on both 'last_name' and 'first_name' columns and you will be able to look them up together or independently.

   Posted 11 months ago #
3. 

   ryoudelman
   Member

   What would I use as the key? What type of partitioner do you use with that type of lookup?

   Posted 11 months ago #
4. 

   xedin
   Member

   As you will be searching by the secondary index columns there is no specific preference about the key, I would do it UUID and go with RandomPartitioner.

   Posted 11 months ago #
5. 

   ryoudelman
   Member

   Thanks.

   Posted 11 months ago #

RSS feed for this topic