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 <>
I dont think it's supported

Anyone else know?


Aaron Morton
Freelance Cassandra Consultant
New Zealand


On 3/04/2013, at 8:11 PM, julien Campan <> wrote:


I'm working with cassandra 1.2.2.

When I try to drop a column , it's not working.

This is what I tried :

  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 ?