You should split the large blobs into multiple rows, and I would use 10MB per row as a good rule of thumb.
See http://www.datastax.com/dev/blog/cassandra-file-system-design for a description of blob store in cassandra Cheers ----------------- Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 20/06/2013, at 8:54 PM, Simon Majou <si...@majou.org> wrote: > Thanks Serge > > Simon > > > On Thu, Jun 20, 2013 at 10:48 AM, Serge Fonville > <serge.fonvi...@gmail.com> wrote: >> Also, after a quick Google. >> >> http://wiki.apache.org/cassandra/CassandraLimitations states values cannot >> exceed 2GB, it also answers you offset question >> >> HTH >> Kind regards/met vriendelijke groet, >> >> Serge Fonville >> >> http://www.sergefonville.nl >> >> Convince Microsoft! >> They need to add TRUNCATE PARTITION in SQL Server >> https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table >> >> >> 2013/6/20 Sachin Sinha <sinha.sac...@gmail.com> >>> >>> Fragment them in rows, that will help. >>> >>> >>> On 20 June 2013 09:43, Simon Majou <si...@majou.org> wrote: >>>> >>>> Hello, >>>> >>>> If I store a video into a column, how can I get a fragment of it >>>> without having to download it entirely ? Is there a way to give an >>>> offset on a column ? >>>> >>>> Do I have to fragment it over a lot of small fixed sizes columns ? Is >>>> there any disadvantage to do so ? For example fragment a 10GB file >>>> into 1 000 columns of 10 MB ? >>>> >>>> Simon >>> >>> >>
