Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
From: Boris Iordanov <biordanov@sabaltech.com>
Content-Type: multipart/alternative; boundary="Apple-Mail=_EB081DA9-EBE7-4118-8B72-A792C99C085E"
Message-Id: <DA7D1C01-BFD4-4C8A-8B62-D1388A7C175D@sabaltech.com>
Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2102\))
Subject: Re: performance penalty of add column in CQL3
Date: Tue, 25 Jul 2017 18:42:31 -0400
References: <C48C1858-C15B-4D05-A373-3A3C448128D9@sabaltech.com> <CAPEQFnEoFM3Dw=4vgayFwvNt2oc-n8-6spQE8bfJeXDtW-RdMg@mail.gmail.com>
To: user@cassandra.apache.org
In-Reply-To: <CAPEQFnEoFM3Dw=4vgayFwvNt2oc-n8-6spQE8bfJeXDtW-RdMg@mail.gmail.com>
archived-at: Tue, 25 Jul 2017 22:42:38 -0000

--Apple-Mail=_EB081DA9-EBE7-4118-8B72-A792C99C085E
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

No, I hadn=E2=80=99t, thanks much for pointing it out!

The take away for me is then that such an update should be done offline. =
In that case, a schema change would be safe and relatively efficient =
(wouldn=E2=80=99t take hours). If that assumption is wrong, could =
anybody let me know?

Thanks much,
Boris

> On Jul 25, 2017, at 5:28 PM, Fay Hou [Storage Service] =C2=AD =
<fayhou@coupang.com> wrote:
>=20
> are you aware this ticket?
> https://issues.apache.org/jira/browse/CASSANDRA-13004 =
<https://issues.apache.org/jira/browse/CASSANDRA-13004>
>=20
> On Tue, Jul 25, 2017 at 1:23 PM, Boris Iordanov =
<biordanov@sabaltech.com <mailto:biordanov@sabaltech.com>> wrote:
> Hi,
>=20
> Is "alter table t add column..." an expensive operation? For example, =
if it's something to be triggered at an admin level of an application =
(i.e. not frequently), is it ok? It won=E2=80=99t trigger rewriting all =
the data, right?
>=20
> My goal is not to have super wide tables, I know that=E2=80=99s not =
the practice with CQL3, but I still want to be able to add a column =
occasionally to a potentially big data set without a huge penalty. What =
are the gothas?
>=20
> Thanks!
> Boris
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org =
<mailto:user-unsubscribe@cassandra.apache.org>
> For additional commands, e-mail: user-help@cassandra.apache.org =
<mailto:user-help@cassandra.apache.org>
>=20
>=20


--Apple-Mail=_EB081DA9-EBE7-4118-8B72-A792C99C085E
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html =
charset=3Dutf-8"></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" =
class=3D"">No, I hadn=E2=80=99t, thanks much for pointing it out!<div =
class=3D""><br class=3D""></div><div class=3D"">The take away for me is =
then that such an update should be done offline. In that case, a schema =
change would be safe and relatively efficient (wouldn=E2=80=99t take =
hours). If that assumption is wrong, could anybody let me =
know?</div><div class=3D""><br class=3D""></div><div class=3D"">Thanks =
much,</div><div class=3D"">Boris</div><div class=3D""><br =
class=3D""><div><blockquote type=3D"cite" class=3D""><div class=3D"">On =
Jul 25, 2017, at 5:28 PM, Fay Hou [Storage Service] =C2=AD &lt;<a =
href=3D"mailto:fayhou@coupang.com" class=3D"">fayhou@coupang.com</a>&gt; =
wrote:</div><br class=3D"Apple-interchange-newline"><div class=3D""><div =
dir=3D"ltr" class=3D""><div class=3D"">are you aware this ticket?<br =
class=3D""></div><a =
href=3D"https://issues.apache.org/jira/browse/CASSANDRA-13004" =
class=3D"">https://issues.apache.org/jira/browse/CASSANDRA-13004</a><br =
class=3D""></div><div class=3D"gmail_extra"><br class=3D""><div =
class=3D"gmail_quote">On Tue, Jul 25, 2017 at 1:23 PM, Boris Iordanov =
<span dir=3D"ltr" class=3D"">&lt;<a =
href=3D"mailto:biordanov@sabaltech.com" target=3D"_blank" =
class=3D"">biordanov@sabaltech.com</a>&gt;</span> wrote:<br =
class=3D""><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 =
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br class=3D"">
<br class=3D"">
Is "alter table t add column..." an expensive operation? For example, if =
it's something to be triggered at an admin level of an application (i.e. =
not frequently), is it ok? It won=E2=80=99t trigger rewriting all the =
data, right?<br class=3D"">
<br class=3D"">
My goal is not to have super wide tables, I know that=E2=80=99s not the =
practice with CQL3, but I still want to be able to add a column =
occasionally to a potentially big data set without a huge penalty. What =
are the gothas?<br class=3D"">
<br class=3D"">
Thanks!<br class=3D"">
Boris<br class=3D"">
------------------------------<wbr =
class=3D"">------------------------------<wbr class=3D"">---------<br =
class=3D"">
To unsubscribe, e-mail: <a =
href=3D"mailto:user-unsubscribe@cassandra.apache.org" =
class=3D"">user-unsubscribe@cassandra.<wbr class=3D"">apache.org</a><br =
class=3D"">
For additional commands, e-mail: <a =
href=3D"mailto:user-help@cassandra.apache.org" =
class=3D"">user-help@cassandra.apache.org</a><br class=3D"">
<br class=3D"">
</blockquote></div><br class=3D""></div>
</div></blockquote></div><br class=3D""></div></body></html>=

--Apple-Mail=_EB081DA9-EBE7-4118-8B72-A792C99C085E--