Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Date: Thu, 01 Dec 2016 13:34:53 -0500
From: Vladimir Yudovin <vladyu@winguzone.com>
To: "user" <user@cassandra.apache.org>
Message-Id: <158bbaaf833.12957cf71177060.1746080307990219038@winguzone.com>
In-Reply-To: <CAHucCEFD2RSK4=96r1ksKktOhMkKxo95r19S=KCEfUYDq+khRQ@mail.gmail.com>
References: <CACj_CzeV+KEfk8w=t-U7wR9rMoZGuv6o4eHTjtkShh4Pnt0jWw@mail.gmail.com> <CAHucCEFD2RSK4=96r1ksKktOhMkKxo95r19S=KCEfUYDq+khRQ@mail.gmail.com>
Subject: Re: Cassandra: maximum size of collection list type
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_556562_1407421487.1480617293878"
User-Agent: Zoho Mail
archived-at: Thu, 01 Dec 2016 18:35:10 -0000

------=_Part_556562_1407421487.1480617293878
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

As doc says:

 The maximum size of an item in a collection is 64K.


Keep collections small to prevent delays during querying because Cassandra =
reads a collection in its entirety. The collection is not paged internally.
As discussed earlier, collections are designed to store only a small amount=
 of data.


Never insert more than 64K items in a collection.=20
If you insert more than 64K items into a collection, only 64K of them will =
be queryable, resulting in data loss.


Best regards, Vladimir Yudovin,=20

Winguzone - Cloud Cassandra Hosting


---- On Thu, 01 Dec 2016 12:17:23 -0500 Benjamin Roth &lt;benjamin.roth@jau=
mo.com&gt; wrote ----


You can read it in the docs but i think it was 2^16 aka 64k


Am 01.12.2016 18:00 schrieb "Selvam Raman" &lt;selmna@gmail.com&gt;:

Hi,


What is the maximum size which can be stored into collection list(in a row =
) in cassandra.


--=20

Selvam Raman

"=E0=AE=B2=E0=AE=9E=E0=AF=8D=E0=AE=9A=E0=AE=AE=E0=AF=8D =E0=AE=A4=E0=AE=B5=
=E0=AE=BF=E0=AE=B0=E0=AF=8D=E0=AE=A4=E0=AF=8D=E0=AE=A4=E0=AF=81 =E0=AE=A8=
=E0=AF=86=E0=AE=9E=E0=AF=8D=E0=AE=9A=E0=AE=AE=E0=AF=8D =E0=AE=A8=E0=AE=BF=
=E0=AE=AE=E0=AE=BF=E0=AE=B0=E0=AF=8D=E0=AE=A4=E0=AF=8D=E0=AE=A4=E0=AF=81"


------=_Part_556562_1407421487.1480617293878
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>=
<meta content=3D"text/html;charset=3DUTF-8" http-equiv=3D"Content-Type"></h=
ead><body ><div style=3D'font-size:10pt;font-family:Verdana,Arial,Helvetica=
,sans-serif;'><div>As doc says:<br></div><ul><li><div>&nbsp;The maximum siz=
e of an item in a collection is 64K.<br></div></li><li><div>Keep collection=
s small to prevent delays during querying because Cassandra reads a collect=
ion in its entirety. The collection is not paged internally.<br>As discusse=
d earlier, collections are designed to store only a small amount of data.<b=
r></div></li><li><div>Never insert more than 64K items in a collection. <br=
>If you insert more than 64K items into a collection, only 64K of them will=
 be queryable, resulting in data loss.<br></div></li></ul><div><br></div><d=
iv id=3D""><div>Best regards, Vladimir Yudovin, <br></div><div><i><a target=
=3D"_blank" href=3D"https://winguzone.com?from=3Dlist">Winguzone</a> - Clou=
d Cassandra Hosting</i><br></div></div><div><br></div><div class=3D"zmail_e=
xtra"><div id=3D"1"><div><br></div><div>---- On Thu, 01 Dec 2016 12:17:23 -=
0500&nbsp;<b>Benjamin Roth &lt;benjamin.roth@jaumo.com&gt;</b> wrote ----<b=
r></div></div><div><br></div><blockquote style=3D"border-left: 1px solid #c=
ccccc; padding-left: 6px; margin:0 0 0 5px"><div><p>You can read it in the =
docs but i think it was 2^16 aka 64k<br></p><div><div><br></div><div><div>A=
m 01.12.2016 18:00 schrieb "Selvam Raman" &lt;<a href=3D"mailto:selmna@gmai=
l.com" target=3D"_blank">selmna@gmail.com</a>&gt;:<br></div><blockquote sty=
le=3D"margin: 0 0 0 0.8ex;border-left: 1.0px rgb(204,204,204) solid;padding=
-left: 1.0ex;"><div dir=3D"ltr"><div style=3D"font-family: georgia , serif;=
font-size: large;color: rgb(116,27,71);">Hi,<br></div><div style=3D"font-fa=
mily: georgia , serif;font-size: large;color: rgb(116,27,71);"><br></div><d=
iv style=3D"font-family: georgia , serif;font-size: large;color: rgb(116,27=
,71);">What is the maximum size which can be stored into collection list(in=
 a row ) in cassandra.<br></div><div><br></div><div>-- <br></div><div><div =
dir=3D"ltr"><div>Selvam Raman<br></div><div><span style=3D"color:rgb(37, 37=
, 37)" class=3D"colour"><span style=3D"font-family:sans-serif" class=3D"fon=
t"><span style=3D"font-size:14px" class=3D"size">"=E0=AE=B2=E0=AE=9E=E0=AF=
=8D=E0=AE=9A=E0=AE=AE=E0=AF=8D =E0=AE=A4=E0=AE=B5=E0=AE=BF=E0=AE=B0=E0=AF=
=8D=E0=AE=A4=E0=AF=8D=E0=AE=A4=E0=AF=81 =E0=AE=A8=E0=AF=86=E0=AE=9E=E0=AF=
=8D=E0=AE=9A=E0=AE=AE=E0=AF=8D =E0=AE=A8=E0=AE=BF=E0=AE=AE=E0=AE=BF=E0=AE=
=B0=E0=AF=8D=E0=AE=A4=E0=AF=8D=E0=AE=A4=E0=AF=81"</span></span></span><br><=
/div></div></div></div></blockquote></div></div></div></blockquote></div><d=
iv><br></div></div></body></html>
------=_Part_556562_1407421487.1480617293878--