You aren't missing anything obvious. That's a bug really. Would you mind opening a ticket on https://issues.apache.org/jira/browse/CASSANDRA?
-- Sylvain On Tue, Mar 26, 2013 at 2:48 AM, Gareth Collins <gareth.o.coll...@gmail.com>wrote: > Hi, > > I created a table with the following structure in cqlsh (Cassandra > 1.2.3 - cql 3): > > CREATE TABLE mytable ( column1 text, > column2 text, > messageId timeuuid, > message blob, > PRIMARY KEY ((column1, column2), messageId)); > > I can quite happily add values to this table. e.g: > > insert into client_queue (column1,column2,messageId,message) VALUES > ('string1','string2',now(),'ABCCDCC123'); > > Yet if I decide I want to set the clustering order on messageId DESC: > > CREATE TABLE mytable ( column1 text, > column2 text, > messageId timeuuid, > message blob, > PRIMARY KEY ((column1, column2), messageId)) WITH CLUSTERING > ORDER BY (messageId DESC); > > and try to do an insert: > > insert into client_queue2 (column1,column2,messageId,message) VALUES > ('string1','string2',now(),'ABCCDCC123'); > > I get the following error: > > Bad Request: Type error: cannot assign result of function now (type > timeuuid) to messageid (type > > 'org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.TimeUUIDType)') > > I am sure I am missing something obvious here, but I don't understand. > Why am I getting an error? What do I need > to do to be able to add an entry to this table? > > thanks in advance, > Gareth >