Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=thelastpickle.com; h=from
	:mime-version:content-type:subject:date:in-reply-to:to
	:references:message-id; q=dns; s=thelastpickle.com; b=dLb1+7C8UZ
	C3QshCXNtjlLLMpzoT+Y5XSaLO+xYa4oGNkVUD3D+v9jQyK3BjIzoZOlVT17SZqL
	gMLSlQQDVYjt4teoY/g1sJLmi8oUF/cmQ07RbTcz30XN/+j31jmqUZyKPWgNskkf
	nW03STeNLwQ6ICUqOCNn5QeYESDFo+2mY=
From: aaron morton <aaron@thelastpickle.com>
Mime-Version: 1.0 (Apple Message framework v1084)
Content-Type: multipart/alternative; boundary=Apple-Mail-1--741564451
Subject: Re: Dropping a built in secondary index on a CF
Date: Thu, 28 Apr 2011 21:32:29 +1200
In-Reply-To: <BANLkTi=tjLaZQaJNZi2NsWWDo1LXqNozpQ@mail.gmail.com>
To: user@cassandra.apache.org
References: <BANLkTimxJQfz7MFtDf8WOgmqwmzNtOEWOg@mail.gmail.com>
 <BANLkTi=-2Wzn=44MTceSuBCgwjO7EZrAcA@mail.gmail.com>
 <BANLkTi=tjLaZQaJNZi2NsWWDo1LXqNozpQ@mail.gmail.com>
Message-Id: <13DA23A3-071D-4F29-8F7D-0671BB01BC35@thelastpickle.com>


--Apple-Mail-1--741564451
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

I can confirm thats the way the code works when processing the CF =
update. Everything is tidied up.

A

On 28 Apr 2011, at 18:50, Roshan Dawrani wrote:

> On Thu, Apr 28, 2011 at 9:56 AM, Xaero S <xaeros.s1@gmail.com> wrote:
>=20
> You just need to use the update column family command on the =
cassandra-cli and specify the columns and their metadata. To get the =
metadata of the columns in the CF, you can do describe keyspace =
<keyspacename>. Keep in mind that, in your update CF command, the other =
columns that must continue to have the secondary index must be =
specified, otherwise, your data goes bad.
>=20
> Thank you.
> =20
> Request the community to correct me if i am wrong.
>=20
> I will just wait for a little confirmation if someone has tried it.
>=20
> For these built-in secondary indexes, another Column Family is created =
behind the scenes, isn't it? Will that be automatically dropped when I =
update the column meta data to drop an index and keep others?
>=20
> --=20
> Roshan
> Blog: http://roshandawrani.wordpress.com/
> Twitter: @roshandawrani
> Skype: roshandawrani
>=20


--Apple-Mail-1--741564451
Content-Transfer-Encoding: 7bit
Content-Type: text/html;
	charset=us-ascii

<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I can confirm thats the way the code works when processing the CF update. Everything is tidied up.<div><br></div><div>A</div><div><br><div><div><div>On 28 Apr 2011, at 18:50, Roshan Dawrani wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div class="gmail_quote">On Thu, Apr 28, 2011 at 9:56 AM, Xaero S <span dir="ltr">&lt;<a href="mailto:xaeros.s1@gmail.com">xaeros.s1@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0.8ex; border-left-width: 1px; border-left-color: rgb(204, 204, 204); border-left-style: solid; padding-left: 1ex; position: static; z-index: auto; ">
<br>You just need to use the update column family command on the cassandra-cli and specify the columns and their metadata. To get the metadata of the columns in the CF, you can do describe keyspace &lt;keyspacename&gt;. Keep in mind that, in your update CF command, the other columns that must continue to have the secondary index must be specified, otherwise, your data goes bad.<br>
</blockquote><div><br></div><div>Thank you.</div><div>&nbsp;</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Request the community to correct me if i am wrong.<br></blockquote><div></div></div><div><br></div><div>I will just wait for a little confirmation if someone has tried it.</div><div><br></div><div>For these built-in secondary indexes, another Column Family is created behind the scenes, isn't it? Will that be automatically dropped when I update the column meta data to drop an index and keep others?</div>
<br>-- <br>Roshan<br>Blog: <a href="http://roshandawrani.wordpress.com/" target="_blank">http://roshandawrani.wordpress.com/</a><br>Twitter: <a href="http://twitter.com/roshandawrani" target="_blank">@roshandawrani</a><br>
Skype: roshandawrani<br><br>
</blockquote></div><br></div></div></body></html>
--Apple-Mail-1--741564451--