I dont think it's supported http://www.datastax.com/docs/1.2/cql_cli/cql/ALTER_TABLE#dropping-typed-col
Anyone else know? Cheers ----------------- Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 3/04/2013, at 8:11 PM, julien Campan <julien.cam...@gmail.com> wrote: > Hi, > > I'm working with cassandra 1.2.2. > > When I try to drop a column , it's not working. > > This is what I tried : > > CREATE TABLE cust ( > ise text PRIMARY KEY, > id_avatar_1 uuid, > id_avatar_2 uuid, > id_avatar_3 uuid, > id_avatar_4 uuid > ) ; > > > cqlsh> ALTER TABLE cust DROP id_avatar_1 ; > > ==>Bad Request: line 1:17 no viable alternative at input 'DROP' > ==>Perhaps you meant to use CQL 2? Try using the -2 option when ==>starting > cqlsh. > > Can someone tell me how to drop a column or if it is a bug ? > > Thank