Re: Get fragments of big files (videos)

2013-06-21 Thread aaron morton
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 Ze

Re: Get fragments of big files (videos)

2013-06-20 Thread Simon Majou
Thanks Serge Simon On Thu, Jun 20, 2013 at 10:48 AM, Serge Fonville 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 Fonv

Re: Get fragments of big files (videos)

2013-06-20 Thread Serge Fonville
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

Re: Get fragments of big files (videos)

2013-06-20 Thread Sachin Sinha
Fragment them in rows, that will help. On 20 June 2013 09:43, Simon Majou 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 s

Get fragments of big files (videos)

2013-06-20 Thread Simon Majou
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