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: domain of ajazam@gmail.com designates
 209.85.215.43 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAPqEvGFqtH=G0nA0onrZMQ7S0h6T_1FRDgmBsiD8uXtJggBTvQ@mail.gmail.com>
References: 
 <CAF+A=7pROwk-9q8D2EdUMMVgbY6X9==S0Wt_9Vo_Sv2tOnMFrQ@mail.gmail.com>
	<CAPqEvGFqtH=G0nA0onrZMQ7S0h6T_1FRDgmBsiD8uXtJggBTvQ@mail.gmail.com>
Date: Wed, 6 Nov 2013 21:13:11 +0000
Message-ID: 
 <CAPqEvGGAoAYJmSASg=pbFwk3HXySH-fsWpxwLTQ09TjePvnKyQ@mail.gmail.com>
Subject: Re: CQL Datatype in Cassandra
From: Jabbar Azam <ajazam@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=001a11c3d9b4dcc34a04ea889dab

--001a11c3d9b4dcc34a04ea889dab
Content-Type: text/plain; charset=ISO-8859-1

Forget. The text value can be upto 2GB in size, but in practice it will be
less.

Thanks

Jabbar Azam


On 6 November 2013 21:12, Jabbar Azam <ajazam@gmail.com> wrote:

> Hello Techy Teck,
>
> Couldn't find any evidence on the datastax website but found this
> http://wiki.apache.org/cassandra/CassandraLimitations
>
> which I believe is correct.
>
>
> Thanks
>
> Jabbar Azam
>
>
> On 6 November 2013 20:19, Techy Teck <comptechgeeky@gmail.com> wrote:
>
>> We are using CQL table like this -
>>
>> CREATE TABLE testing (
>>   description text,
>>   last_modified_date timeuuid,
>>   employee_id text,
>>   value text,
>>   PRIMARY KEY (employee_name, last_modified_date)
>> )
>>
>>
>> We have made description as text in the above table. I am thinking is
>> there any limitations on text data type in CQL such as it can only have
>> certain number of bytes and after that it will truncate?
>>
>> Any other limitations that I should be knowing? Should I use blob there?
>>
>>
>

--001a11c3d9b4dcc34a04ea889dab
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Forget. The text value can be upto 2GB in size, but in pra=
ctice it will be less.</div><div class=3D"gmail_extra"><br clear=3D"all"><d=
iv><div dir=3D"ltr">Thanks<br><br>Jabbar Azam<br></div></div>
<br><br><div class=3D"gmail_quote">On 6 November 2013 21:12, Jabbar Azam <s=
pan dir=3D"ltr">&lt;<a href=3D"mailto:ajazam@gmail.com" target=3D"_blank">a=
jazam@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 Techy Teck,<div><br></div><div>Couldn&#39;t find any=
 evidence on the datastax website but found this=A0<a href=3D"http://wiki.a=
pache.org/cassandra/CassandraLimitations" target=3D"_blank">http://wiki.apa=
che.org/cassandra/CassandraLimitations</a></div>

<div><br></div><div>which I believe is correct.</div><div><br></div></div><=
div class=3D"gmail_extra"><br clear=3D"all"><div><div dir=3D"ltr">Thanks<sp=
an class=3D"HOEnZb"><font color=3D"#888888"><br><br>Jabbar Azam<br></font><=
/span></div>
</div><div><div class=3D"h5">
<br><br><div class=3D"gmail_quote">On 6 November 2013 20:19, Techy Teck <sp=
an dir=3D"ltr">&lt;<a href=3D"mailto:comptechgeeky@gmail.com" target=3D"_bl=
ank">comptechgeeky@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"><div><div>We are using CQL table like this - <br><br>CREAT=
E TABLE testing (<br>=A0 description text,<br>=A0 last_modified_date timeuu=
id,<br>=A0 employee_id text,<br>=A0 value text,<br>=A0 PRIMARY KEY (employe=
e_name, last_modified_date)<br>


)<br><br><br></div>We have made description as text in the above table. I a=
m thinking is there any limitations on text data type in CQL such as it can=
 only have certain number of bytes and after that it will truncate?<br>


<br></div>Any other limitations that I should be knowing? Should I use blob=
 there?<br><div><br></div></div>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div>

--001a11c3d9b4dcc34a04ea889dab--