http://www.datastax.com/support-forums/tags/composite-columns Software, Support, and Training for Apache Cassandra en-US Wed, 19 Jun 2013 06:35:46 +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> http://www.datastax.com/support-forums/topic/composite-column-using#post-1090 Mon, 06 Feb 2012 15:21:16 +0000 Anonymous 1090@http://www.datastax.com/support-forums/ <p>As promised this is fixed in the 1.4 release.</p> <p>Problem solved. </p> http://www.datastax.com/support-forums/topic/composite-column-using#post-837 Mon, 12 Dec 2011 20:08:31 +0000 mbulman 837@http://www.datastax.com/support-forums/ <p>Thanks for the info. I was able to reproduce this. It's related to the "#" in your key. We'll be sure to get this fixed in a future version of OpsCenter (unable to provide timeframe at this point).</p> <p>Let us know if you have any more questions. </p> http://www.datastax.com/support-forums/topic/composite-column-using#post-835 Fri, 09 Dec 2011 14:37:07 +0000 Anonymous 835@http://www.datastax.com/support-forums/ <p>By the way I'm running Opscenter 1.3, if you need any additional information just let me know. </p> http://www.datastax.com/support-forums/topic/composite-column-using#post-834 Fri, 09 Dec 2011 09:21:11 +0000 Anonymous 834@http://www.datastax.com/support-forums/ <p>I'm working on win7 + chrome (15.0.874.121 m), same problem on FF (8.0). My OpsCenter is set up on Ubuntu 11.10.</p> <p>I confirm that I choose "Key" from the dropdown, and not "Hex Key" (I also tried with "Hex Key", and I indeed get the same error) </p> http://www.datastax.com/support-forums/topic/composite-column-using#post-829 Thu, 08 Dec 2011 22:47:49 +0000 mbulman 829@http://www.datastax.com/support-forums/ <p>That error should only occur if you choose "Hex key" from the dropdown. What browser and OS combination are you loading OpsCenter in? </p> http://www.datastax.com/support-forums/topic/composite-column-using#post-828 Thu, 08 Dec 2011 10:45:33 +0000 Anonymous 828@http://www.datastax.com/support-forums/ <p>Hi, I have some composite columns using # like 20111208#event.</p> <p>When I try to use opscenter to get this column name or row key I get this error "Error loading data: hexkey must be 0 or 1" even if I am using "key" filter and not the "Hex key" filter.</p> <p>Is there a workaround to get my data ?</p> <p>Alain </p>