Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A27A7F016 for ; Wed, 3 Apr 2013 14:41:51 +0000 (UTC) Received: (qmail 95909 invoked by uid 500); 3 Apr 2013 14:41:49 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 95410 invoked by uid 500); 3 Apr 2013 14:41:48 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 95383 invoked by uid 99); 3 Apr 2013 14:41:48 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Apr 2013 14:41:48 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of julien.campan@gmail.com designates 209.85.223.180 as permitted sender) Received: from [209.85.223.180] (HELO mail-ie0-f180.google.com) (209.85.223.180) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Apr 2013 14:41:41 +0000 Received: by mail-ie0-f180.google.com with SMTP id a11so1711427iee.25 for ; Wed, 03 Apr 2013 07:41:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:date:message-id:subject:from:to :content-type; bh=7Po/zKzQNpWtKRGd+I5dogfRBveEcMdDNC8QXyJZO84=; b=wtlcXTIMGQkvLpkl6iz2jZJ2bBO9Nkhi+dYysXsHIMJ0LbAo/FYqppL+1rD25UuReo 4aFOKE7jvt+HutD8KckdxTMGKFH/KJ1giWcoCd0I8MZ6LqHl9TyW98Qjrn0DXUDtGRoB nrnSCdvhBpZVW0T0uTvQj5htmA+Ofw2kpNKvwySBXNBGrGJ8pwcCwT9OOfhBFWtdDVUJ C8MuDNbJirsqqIykUT94B4oE8hvIopbPYBGoF8gWCr42tyamnWMe/gpW+gq+1Ut6Rgvy oPvFoRMQP1YyK+2jhQXG669q+smVtN+1mVuqL3Lxu4RaWD9T1ATqd+CkLQL/0L0Mga1R aL+g== MIME-Version: 1.0 X-Received: by 10.50.150.146 with SMTP id ui18mr7457471igb.21.1365000080866; Wed, 03 Apr 2013 07:41:20 -0700 (PDT) Received: by 10.64.63.68 with HTTP; Wed, 3 Apr 2013 07:41:20 -0700 (PDT) Date: Wed, 3 Apr 2013 16:41:20 +0200 Message-ID: Subject: Alter table drop column seems not working From: julien Campan To: user Content-Type: multipart/alternative; boundary=f46d043c7d3af161d504d975d828 X-Virus-Checked: Checked by ClamAV on apache.org --f46d043c7d3af161d504d975d828 Content-Type: text/plain; charset=ISO-8859-1 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 --f46d043c7d3af161d504d975d828 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

Hi,

I'm working with = cassandra 1.2.2.

When I try to drop a column , it's not w= orking.

This is what I tried :

CREATE TABLE cust ( =A0 ise text PRIMARY KEY,
=A0 id_avatar_1 uuid,
=A0 id_avatar_2 uuid,=
=A0 id_avatar_3 uuid,
=A0 id_avatar_4 uuid
) ;

cqlsh&g= t; ALTER TABLE cust DROP id_avatar_1 ;

=3D=3D>Bad Request: line 1= :17 no viable alternative at input 'DROP'
=3D=3D>Perhaps you meant to use CQL 2? Try using the -2 option when =3D= =3D>starting cqlsh.

Can someone=A0 tell me how to drop= a column or if it is a bug ?

Thank

--f46d043c7d3af161d504d975d828--