http://www.datastax.com/support-forums/topic/cql-and-the-ability-to-implement-tagging Software, Support, and Training for Apache Cassandra en-US Mon, 20 May 2013 03:14:54 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/cql-and-the-ability-to-implement-tagging#post-1461 Thu, 29 Mar 2012 18:03:33 +0000 Anonymous 1461@http://www.datastax.com/support-forums/ <p>Thanks for the heads up! </p> http://www.datastax.com/support-forums/topic/cql-and-the-ability-to-implement-tagging#post-1450 Wed, 28 Mar 2012 22:28:36 +0000 thepaul 1450@http://www.datastax.com/support-forums/ <p>The Python driver does support cql3, for what it's worth. </p> http://www.datastax.com/support-forums/topic/cql-and-the-ability-to-implement-tagging#post-1417 Thu, 22 Mar 2012 04:31:08 +0000 jbellis 1417@http://www.datastax.com/support-forums/ <p>I don't think the JDBC driver supports CQL3 yet either. </p> http://www.datastax.com/support-forums/topic/cql-and-the-ability-to-implement-tagging#post-1400 Tue, 20 Mar 2012 13:01:22 +0000 Anonymous 1400@http://www.datastax.com/support-forums/ <p>Thanks for the help, I compile from source so I'm using 1.1.0-beta and the latest JDBC.</p> <p>I'm assuming the composite primary key will have to be created via JDBC rather than ./cqlsh as it doesn't yet support CQL 2+? </p> http://www.datastax.com/support-forums/topic/cql-and-the-ability-to-implement-tagging#post-1397 Tue, 20 Mar 2012 02:28:45 +0000 jbellis 1397@http://www.datastax.com/support-forums/ <p>Better would be to denormalize just one level:</p> <p>CREATE TABLE post_tags (<br /> post_id uuid,<br /> tag string,<br /> PRIMARY KEY (post_id, tag)<br /> );</p> <p>(See <a href="http://www.datastax.com/dev/blog/schema-in-cassandra-1-1" rel="nofollow">http://www.datastax.com/dev/blog/schema-in-cassandra-1-1</a> for discussion on composite PKs.)</p> <p>For Cassandra 1.0 you'd need to manually spell out the wide row nature by specifying the comparator and validator instead. </p> http://www.datastax.com/support-forums/topic/cql-and-the-ability-to-implement-tagging#post-1390 Mon, 19 Mar 2012 10:20:28 +0000 Anonymous 1390@http://www.datastax.com/support-forums/ <p>So essentially I would be normalising the data as follows:</p> <pre><code>posts { id uuid ... } postTags { id binary, // hash / checksum tag string } postTagsMap { postID uuid, tagID binary }</code></pre> <p>Makes sense really as it allows indexing on tags and tag/post ID maps, although it feels very RDBMS (I don't mind). </p> http://www.datastax.com/support-forums/topic/cql-and-the-ability-to-implement-tagging#post-1386 Sun, 18 Mar 2012 20:18:26 +0000 jbellis 1386@http://www.datastax.com/support-forums/ <p>You'd have to split the tags out into a separate columnfamily.</p> <p><a href="https://issues.apache.org/jira/browse/CASSANDRA-3647" rel="nofollow">https://issues.apache.org/jira/browse/CASSANDRA-3647</a> is open to support lists, maps, and sets directly as column values. </p> http://www.datastax.com/support-forums/topic/cql-and-the-ability-to-implement-tagging#post-1384 Sun, 18 Mar 2012 17:44:33 +0000 Anonymous 1384@http://www.datastax.com/support-forums/ <p>Would it be possible to implement this column family and query/insert such via CQL?</p> <p>post {<br /> id: 1<br /> title: "Hello Dennis"<br /> body: "Post body..."<br /> timestamp '2012-03-18 17:41:55'<br /> tags: ["hello", "world", "testing"]<br /> }</p> <p>"tags" would also need to be indexable - to the best of my knowledge the above isn't possible when interfacing via CQL, I've read up on composite columns but information is disturbing thin. If anyone could help direct me it'd be much appreciated.</p> <p>Cheers! </p>