http://www.datastax.com/support-forums/topic/how-to-add-column-and-insert-value-for-dynamiccompositetype-using-cql Software, Support, and Training for Apache Cassandra en-US Thu, 23 May 2013 23:11:03 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/how-to-add-column-and-insert-value-for-dynamiccompositetype-using-cql#post-783 Tue, 29 Nov 2011 20:28:29 +0000 zznate 783@http://www.datastax.com/support-forums/ <p>Ed's CQL examples are mostly illustrative - the values are not filled in on the slide as they would be the raw bytes of the composite column as a whole. (You could do this for select, update and insert statements, but would mean you handle the byte conversion to an from by hand). </p> http://www.datastax.com/support-forums/topic/how-to-add-column-and-insert-value-for-dynamiccompositetype-using-cql#post-782 Tue, 29 Nov 2011 19:06:50 +0000 Anonymous 782@http://www.datastax.com/support-forums/ <p>I was bit tempted to play with CQL when I saw Ed Anuff's presentation about Cassandra Indexing Techniques. Presentation has some semantics for composite CQL statements.</p> <p>Thanks for quick response. </p> http://www.datastax.com/support-forums/topic/how-to-add-column-and-insert-value-for-dynamiccompositetype-using-cql#post-781 Tue, 29 Nov 2011 05:44:13 +0000 zznate 781@http://www.datastax.com/support-forums/ <p>Composite columns (dynamic or static) are not yet supported in CQL. See <a href="https://issues.apache.org/jira/browse/CASSANDRA-2474" rel="nofollow">https://issues.apache.org/jira/browse/CASSANDRA-2474</a> for tracking. </p> http://www.datastax.com/support-forums/topic/how-to-add-column-and-insert-value-for-dynamiccompositetype-using-cql#post-780 Tue, 29 Nov 2011 05:11:23 +0000 Anonymous 780@http://www.datastax.com/support-forums/ <p>Hi,</p> <p>I have created column family.</p> <p>create columnfamily comptest2(KEY varchar primary key) with comparator='DynamicCompositeType(s=&gt;UTF8Type,u=&gt;UTF8Type)';</p> <p>I am trying to add Composite column using alter statement but I am getting error. I tried all possible options I can think of.</p> <p>cqlsh&gt; alter table comptest2 add {"col1","col2"} ;<br /> Bad Request: line 1:43 no viable alternative at character '}'</p> <p>cqlsh&gt; alter table comptest2 add {"col1","col2"} {varchar,varchar};<br /> Bad Request: line 1:61 no viable alternative at character '}'</p> <p>What am I doing wrong?</p> <p>Thanks,<br /> R </p>