http://www.datastax.com/support-forums/topic/columnfamily-design Software, Support, and Training for Apache Cassandra en-US Thu, 23 May 2013 23:25:04 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/columnfamily-design#post-2379 Mon, 25 Jun 2012 19:02:01 +0000 ryoudelman 2379@http://www.datastax.com/support-forums/ <p>Thanks. </p> http://www.datastax.com/support-forums/topic/columnfamily-design#post-2366 Mon, 25 Jun 2012 17:17:44 +0000 xedin 2366@http://www.datastax.com/support-forums/ <p>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. </p> http://www.datastax.com/support-forums/topic/columnfamily-design#post-2364 Mon, 25 Jun 2012 17:05:45 +0000 ryoudelman 2364@http://www.datastax.com/support-forums/ <p>What would I use as the key? What type of partitioner do you use with that type of lookup? </p> http://www.datastax.com/support-forums/topic/columnfamily-design#post-2361 Mon, 25 Jun 2012 16:33:09 +0000 xedin 2361@http://www.datastax.com/support-forums/ <p>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. </p> http://www.datastax.com/support-forums/topic/columnfamily-design#post-2359 Mon, 25 Jun 2012 16:24:05 +0000 ryoudelman 2359@http://www.datastax.com/support-forums/ <p>I am looking for some guidance on the best way to design a column family to lookup users given the following constraints:</p> <p>Last Name and First Name with on 3 characters of each being required</p> <p>Any guidance is appreciated. </p>