incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From julien Campan <julien.cam...@gmail.com>
Subject Re: Alter table drop column seems not working
Date Thu, 04 Apr 2013 13:41:09 GMT
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 <aaron@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.campan@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
>
>
>

Mime
View raw message