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
>
>

Reply via email to