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
>
