You are right, the documentation says that this action is not supported. I was surprised because the "auto completion" in cqlsh allows you to try it and, moreover, you have an example of a drop column when you use "help alter_drop".
Maybe it would be nice to change at least the documentation and auto-completion ? 2013/4/4 aaron morton <aa...@thelastpickle.com> > 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 > > >
