Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: local policy)
From: Phil Stanhope <pstanhope@wimba.com>
Mime-Version: 1.0 (Apple Message framework v1078)
Content-Type: multipart/alternative; boundary=Apple-Mail-13-87923586
Subject: Re: what is the best way to truncate a column family
Date: Fri, 18 Jun 2010 17:09:10 -0400
In-Reply-To: <AANLkTik-h1-D9F3NlogkNNhDBgZ9R4-9vupw1WXOJXS6@mail.gmail.com>
To: user@cassandra.apache.org
References: <D12BD8F8-CE0A-4FD1-A9BC-20ED8A958F3C@merchantcircle.com>
  <AANLkTin3a85JQoBcIHVyFQ1FT7Xu23OK7Hf5r1P2V4ru@mail.gmail.com>
  <435C011F-9E17-4DB0-856C-F8D6C3293F02@wimba.com>
 <AANLkTik-h1-D9F3NlogkNNhDBgZ9R4-9vupw1WXOJXS6@mail.gmail.com>
Message-Id: <EAD19090-1092-4C48-9828-C90B3DBE6355@wimba.com>


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

I am happy with this restriction on truncate operation for 0.7. Thanks =
for the quick response.

-phil

On Jun 18, 2010, at 4:57 PM, Ran Tavory wrote:

> it will be immediate.=20
> But it will fail if not all hosts in the cluster are up, this is the =
tradeoff. We regard the truncate operation an admin api so I think it's =
a fair tradeoff.=20
>=20
> On Fri, Jun 18, 2010 at 11:50 PM, Phil Stanhope <pstanhope@wimba.com> =
wrote:
> In 0.6.x the iterating approach works ... but you need to flush and =
compact (after GCGraceSeconds) in order to NOT see the keys in the CF.
>=20
> Will the behavior of the truncate method in 0.7 require flush/compact =
as well? Or will it be immediate?
>=20
> -phil
>=20
> On Jun 18, 2010, at 1:29 PM, Benjamin Black wrote:
>=20
> > In 0.6 your only option with those constraints is to iterate over =
the
> > entire CF and deleting row by row.  This requires you are either =
using
> > OPP or have an index that covers all keys in the CF.  0.7 adds the
> > ability to truncate a CF (deleting all its rows) through the API.
> >
> > On Fri, Jun 18, 2010 at 10:24 AM, Claire Chang
> > <claire@merchantcircle.com> wrote:
> >> programmatically w/o bringing the servers down.
> >>
> >> thanks,
> >> claire
> >>
>=20
>=20


--Apple-Mail-13-87923586
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 am happy with this restriction on truncate operation for 0.7. Thanks for the quick response.<div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div>-phil</div></span>
</div>
<br><div><div>On Jun 18, 2010, at 4:57 PM, Ran Tavory wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr">it will be immediate.&nbsp;<div>But it will fail if not all hosts in the cluster are up, this is the tradeoff. We regard the truncate operation an admin api so I think it's a fair tradeoff.&nbsp;<br><br><div class="gmail_quote">

On Fri, Jun 18, 2010 at 11:50 PM, Phil Stanhope <span dir="ltr">&lt;<a href="mailto:pstanhope@wimba.com">pstanhope@wimba.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">

In 0.6.x the iterating approach works ... but you need to flush and compact (after GCGraceSeconds) in order to NOT see the keys in the CF.<br>
<br>
Will the behavior of the truncate method in 0.7 require flush/compact as well? Or will it be immediate?<br>
<font color="#888888"><br>
-phil<br>
</font><div><div></div><div class="h5"><br>
On Jun 18, 2010, at 1:29 PM, Benjamin Black wrote:<br>
<br>
&gt; In 0.6 your only option with those constraints is to iterate over the<br>
&gt; entire CF and deleting row by row. &nbsp;This requires you are either using<br>
&gt; OPP or have an index that covers all keys in the CF. &nbsp;0.7 adds the<br>
&gt; ability to truncate a CF (deleting all its rows) through the API.<br>
&gt;<br>
&gt; On Fri, Jun 18, 2010 at 10:24 AM, Claire Chang<br>
&gt; &lt;<a href="mailto:claire@merchantcircle.com">claire@merchantcircle.com</a>&gt; wrote:<br>
&gt;&gt; programmatically w/o bringing the servers down.<br>
&gt;&gt;<br>
&gt;&gt; thanks,<br>
&gt;&gt; claire<br>
&gt;&gt;<br>
<br>
</div></div></blockquote></div><br></div></div>
</blockquote></div><br></div></body></html>
--Apple-Mail-13-87923586--