http://www.datastax.com/support-forums/topic/composit-columns-for-name-field Software, Support, and Training for Apache Cassandra en-US Sat, 25 May 2013 04:07:56 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/composit-columns-for-name-field#post-3712 Wed, 25 Jul 2012 09:20:46 +0000 xedin 3712@http://www.datastax.com/support-forums/ <p>I suggest you to take a look at this <a href="http://www.datastax.com/dev/blog/introduction-to-composite-columns-part-1" rel="nofollow">http://www.datastax.com/dev/blog/introduction-to-composite-columns-part-1</a> , which has detailed description of the problem and answers to all 3 of your questions. </p> http://www.datastax.com/support-forums/topic/composit-columns-for-name-field#post-3660 Wed, 25 Jul 2012 01:47:15 +0000 akhil.bansal 3660@http://www.datastax.com/support-forums/ <p>Thanks xedin this is what i was looking for.</p> <p>1. How does it differs from storing the individual columns at column family level as compared to composite column ?</p> <p>2. Does composite column offer any advantage in column retrieval over the data retrieval from individual columns ?</p> <p>3. How specifying CompositeType for a column is different from specifying a composite for the column family (comparator)? I have seen lots of syntax on net for composite column where CompositeType is specified for comparator instead of Validate_class for column. And all the articles were for composite columns only. </p> http://www.datastax.com/support-forums/topic/composit-columns-for-name-field#post-3639 Tue, 24 Jul 2012 20:04:36 +0000 xedin 3639@http://www.datastax.com/support-forums/ <p>Yes, you can use composites in this case, you will need to have CompositeType(UTF8Type, UTF8Type, UTF8Type) which would handle the Suffix, first/last name and CompositeType(Int32Type, UTF8Type, UTF8Type, Int32Type, UTF8Type) for house/street/city/state and country.</p> <p>CLI syntax:</p> <p>create column family cf with key_validation_class=UTF8Type and comparator=AsciiType and column_metadata=[{column_name:name, validation_class:'CompositeType(UTF8Type, UTF8Type, UTF8Type)'}, {column_name:address, validation_class:'CompositeType(Int32Type, UTF8Type, UTF8Type, Int32Type, UTF8Type)'}];</p> <p>But it also depends and how do you want to query the data, if you would query only specific columns (e.g. first name) you can go with secondary indices instead of composites. </p> http://www.datastax.com/support-forums/topic/composit-columns-for-name-field#post-3616 Tue, 24 Jul 2012 16:47:02 +0000 akhil.bansal 3616@http://www.datastax.com/support-forums/ <p>Hi, I have a column family for storing customer details. Column Family will have CustomerCode as key and below mentioned fields</p> <p>email address<br /> Name<br /> First Name<br /> last name<br /> Suffix</p> <p>Address<br /> House#<br /> Street<br /> City<br /> State<br /> Country.</p> <p>where name should be the combined values of Suffix, First Name ,last name<br /> and address should be the combined value of House#, Street, City, State and Country</p> <p>Does composite columns be used in this situations ?</p> <p>Can you please guide with the syntax for creating this column family where we have two composite columns and each has different number of columns ? </p>