Added: https://issues.apache.org/jira/browse/CASSANDRA-5472
thanks, Gareth On Sun, Apr 14, 2013 at 2:33 PM, aaron morton <aa...@thelastpickle.com>wrote: > Bad Request: Type error: > org.apache.cassandra.cql3.statements.Selection$SimpleSelector@1e7318cannot be > passed as argument 0 of function dateof of type timeuuid > > Is there something I am missing here or should I open a new ticket? > > Yes please. > > Cheers > > ----------------- > Aaron Morton > Freelance Cassandra Consultant > New Zealand > > @aaronmorton > http://www.thelastpickle.com > > On 13/04/2013, at 4:40 PM, Gareth Collins <gareth.o.coll...@gmail.com> > wrote: > > OK, trying out 1.2.4. The previous issue seems to be fine, but I am > experiencing a new one: > > cqlsh:location> create table test_y (message_id timeuuid, name text, > PRIMARY KEY (name,message_id)); > cqlsh:location> insert into test_y (message_id,name) VALUES (now(),'foo'); > cqlsh:location> insert into test_y (message_id,name) VALUES (now(),'foo'); > cqlsh:location> insert into test_y (message_id,name) VALUES (now(),'foo'); > cqlsh:location> insert into test_y (message_id,name) VALUES (now(),'foo'); > cqlsh:location> select dateOf(message_id) from test_y; > > dateOf(message_id) > -------------------------- > 2013-04-13 00:33:42-0400 > 2013-04-13 00:33:43-0400 > 2013-04-13 00:33:43-0400 > 2013-04-13 00:33:44-0400 > > cqlsh:location> create table test_x (message_id timeuuid, name text, > PRIMARY KEY (name,message_id)) WITH CLUSTERING ORDER BY (message_id DESC); > cqlsh:location> insert into test_x (message_id,name) VALUES (now(),'foo'); > cqlsh:location> insert into test_x (message_id,name) VALUES (now(),'foo'); > cqlsh:location> insert into test_x (message_id,name) VALUES (now(),'foo'); > cqlsh:location> insert into test_x (message_id,name) VALUES (now(),'foo'); > cqlsh:location> insert into test_x (message_id,name) VALUES (now(),'foo'); > cqlsh:location> select dateOf(message_id) from test_x; > Bad Request: Type error: > org.apache.cassandra.cql3.statements.Selection$SimpleSelector@1e7318cannot be > passed as argument 0 of function dateof of type timeuuid > > Is there something I am missing here or should I open a new ticket? > > thanks in advance, > Gareth > > > On Tue, Mar 26, 2013 at 3:30 PM, Gareth Collins < > gareth.o.coll...@gmail.com> wrote: > >> 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 >> > >> > >> > > >