Added: https://issues.apache.org/jira/browse/CASSANDRA-5386
Thanks very much for the quick answer! regards, Gareth On Tue, Mar 26, 2013 at 3:55 AM, Sylvain Lebresne <sylv...@datastax.com> wrote: > 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 > >