Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
MIME-Version: 1.0
References: 
 <CAEm4zQzPpAJ3FvO-OK7d9Zaji_+MMoyXRcbmAiwixhrKY=BALg@mail.gmail.com>
 <CAJ8Xi+RyCc6+haDnBpaVcr73jJPvmbY_HcQrFhuLSyk8Zw8L_Q@mail.gmail.com>
 <CAEm4zQwYvKYf96hvSW6BGH_Kf8W935h21KStyRBs4HUfWiw0Vw@mail.gmail.com>
In-Reply-To: 
 <CAEm4zQwYvKYf96hvSW6BGH_Kf8W935h21KStyRBs4HUfWiw0Vw@mail.gmail.com>
From: =?UTF-8?B?RW3Eq2xzIMWgb2xtYW5pcw==?= <emils.solmanis@gmail.com>
Date: Thu, 10 Mar 2016 17:39:21 +0000
Message-ID: 
 <CAEm4zQy_Gse_iYPcQXO7tJLgbn5s9PryS33BRMY-p4bx0t_qeQ@mail.gmail.com>
Subject: Re: Exception about too long clustering key
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=001a1148bcf0f9f784052db54b82

--001a1148bcf0f9f784052db54b82
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

In case someone stumbles upon this same thing later.

Ended up being a collection item that was too big (i.e., larger than 64K).
Something to do with the way Cassandra generates the keys for collections,
but moving the offending collection from a list<UDT> to a separate
clustering key solved this particular instance. The error message could
definitely be better though, and I'll raise it with the devs.

Regards,
Emils

On Wed, 9 Mar 2016 at 20:31 Em=C4=ABls =C5=A0olmanis <emils.solmanis@gmail.=
com> wrote:

> Hey Alex,
>
> I did do a grep for that message in the driver code base and it seems lik=
e
> it's not there, so I think this is coming from the server.
>
> Only thing I can think of is us exceeding one of the limits (e.g., the 65=
K
> collection item one) and then the error message being super misleading.
> I'll check the server code tomorrow and see if I can track that message
> down.
>
> Regards,
> Emils
>
> On Wed, 9 Mar 2016 20:02 Alex Popescu, <alexp@datastax.com> wrote:
>
>> Hi Em=C4=ABls,
>>
>> Directing this question to the Java driver mailing list will give you
>> better chances to get an answer:
>> https://groups.google.com/a/lists.datastax.com/forum/#!forum/java-driver=
-user
>>
>> (as a side note, I haven't seen this one before)
>>
>> On Wed, Mar 9, 2016 at 11:52 AM, Em=C4=ABls =C5=A0olmanis <emils.solmani=
s@gmail.com
>> > wrote:
>>
>>> Hello,
>>>
>>> I keep getting an exception about a clustering key being too long, like
>>>
>>> com.datastax.driver.core.exceptions.InvalidQueryException: The sum of a=
ll clustering columns is too long (72650 > 65535)
>>> 	at com.datastax.driver.core.Responses$Error.asException(Responses.java=
:136)
>>> 	at com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResult=
SetFuture.java:179)
>>> 	at com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandl=
er.java:184)
>>>
>>>
>>> But the table has no clustering key. Even if I set the clustering key t=
o
>>> a single column that's guaranteed to be a string around 4-5 characters,=
 I
>>> get the same thing.
>>>
>>> The only result Google gave me suggested this was about the clustering
>>> key names, so I renamed all the fields in the schema def to 1-3 letters=
, to
>>> no avail.
>>>
>>> Does anyone know what this is about and how I can solve this?
>>>
>>> Running Cassandra 2.2.4, Datastax driver 3.0.0.
>>>
>>> Regards,
>>> Emils
>>>
>>
>>
>>
>> --
>> Bests,
>>
>> Alex Popescu | @al3xandru
>> Sen. Product Manager @ DataStax
>>
>>

--001a1148bcf0f9f784052db54b82
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">In case someone stumbles upon this same thing later.<div><=
br></div><div>Ended up being a collection item that was too big (i.e., larg=
er than 64K). Something to do with the way Cassandra generates the keys for=
 collections, but moving the offending collection from a list&lt;UDT&gt; to=
 a separate clustering key solved this particular instance. The error messa=
ge could definitely be better though, and I&#39;ll raise it with the devs.<=
/div><div><br></div><div>Regards,</div><div>Emils</div></div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr">On Wed, 9 Mar 2016 at 20:31 Em=C4=ABls =
=C5=A0olmanis &lt;<a href=3D"mailto:emils.solmanis@gmail.com">emils.solmani=
s@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=
=3D"ltr">Hey Alex, </div><span>
</span><p dir=3D"ltr">I did do a grep for that message in the driver code b=
ase and it seems like it&#39;s not there, so I think this is coming from th=
e server. </p><span>
</span><p dir=3D"ltr">Only thing I can think of is us exceeding one of the =
limits (e.g., the 65K collection item one) and then the error message being=
 super misleading. I&#39;ll check the server code tomorrow and see if I can=
 track that message down. </p><span>
</span><p dir=3D"ltr">Regards, <br>
Emils <br>
</p><span>
</span><br><div class=3D"gmail_quote"><div dir=3D"ltr">On Wed, 9 Mar 2016 2=
0:02 Alex Popescu, &lt;<a href=3D"mailto:alexp@datastax.com" target=3D"_bla=
nk">alexp@datastax.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_q=
uote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1e=
x"><div dir=3D"ltr">Hi=C2=A0Em=C4=ABls,<div><br></div><div>Directing this q=
uestion to the Java driver mailing list will give you better chances to get=
 an answer:=C2=A0<a href=3D"https://groups.google.com/a/lists.datastax.com/=
forum/#!forum/java-driver-user" target=3D"_blank">https://groups.google.com=
/a/lists.datastax.com/forum/#!forum/java-driver-user</a></div><div><br></di=
v><div>(as a side note, I haven&#39;t seen this one before)</div></div><div=
 class=3D"gmail_extra"></div><div class=3D"gmail_extra"><br><div class=3D"g=
mail_quote">On Wed, Mar 9, 2016 at 11:52 AM, Em=C4=ABls =C5=A0olmanis <span=
 dir=3D"ltr">&lt;<a href=3D"mailto:emils.solmanis@gmail.com" target=3D"_bla=
nk">emils.solmanis@gmail.com</a>&gt;</span> wrote:<br><blockquote class=3D"=
gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-=
left:1ex"><div dir=3D"ltr">Hello,<div><br></div><div>I keep getting an exce=
ption about a clustering key being too long, like</div><div><pre style=3D"c=
olor:rgb(0,0,0);line-height:normal">com.datastax.driver.core.exceptions.Inv=
alidQueryException: The sum of all clustering columns is too long (72650 &g=
t; 65535)
	at com.datastax.driver.core.Responses$Error.asException(Responses.java:136=
)
	at com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetF=
uture.java:179)
	at com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.j=
ava:184)
</pre></div><div><br></div><div>But the table has no clustering key. Even i=
f I set the clustering key to a single column that&#39;s guaranteed to be a=
 string around 4-5 characters, I get the same thing.=C2=A0</div><div><br></=
div><div>The only result Google gave me suggested this was about the cluste=
ring key names, so I renamed all the fields in the schema def to 1-3 letter=
s, to no avail.</div><div><br></div><div>Does anyone know what this is abou=
t and how I can solve this?</div><div><br></div><div>Running Cassandra 2.2.=
4, Datastax driver 3.0.0.</div><div><br></div><div>Regards,</div><div>Emils=
</div></div>
</blockquote></div><br><br clear=3D"all"><div><br></div></div><div class=3D=
"gmail_extra">-- <br><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div =
dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div>Bests,</d=
iv><div><br>Alex Popescu |=C2=A0<span style=3D"line-height:1.6em">@al3xandr=
u</span></div><div dir=3D"ltr">Sen. Product Manager @ DataStax<br><br></div=
></div></div></div></div></div></div></div></div></div></div></div>
</div></blockquote></div></blockquote></div>

--001a1148bcf0f9f784052db54b82--