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

Reply via email to