incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: Get fragments of big files (videos)
Date Fri, 21 Jun 2013 08:15:13 GMT
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 <simon@majou.org> wrote:

> Thanks Serge
> 
> Simon
> 
> 
> On Thu, Jun 20, 2013 at 10:48 AM, Serge Fonville
> <serge.fonville@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.sachin@gmail.com>
>>> 
>>> Fragment them in rows, that will help.
>>> 
>>> 
>>> On 20 June 2013 09:43, Simon Majou <simon@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
>>> 
>>> 
>> 


Mime
View raw message