Send large blobs

Hi, I want to write large blobs in Cassandra. However, when I tried to write more than a 256MB blob, I got the message: "Error from server: code=2200 [Invalid query] message=\"Request is too big: length 268435580 exceeds maximum allowed length 268435456.\"". I tried to change the variables "max

Re: Send large blobs

On Tue, May 31, 2022 at 4:40 PM Andria Trigeorgi wrote: > Hi, > > I want to write large blobs in Cassandra. However, when I tried to write > more than a 256MB blob, I got the message: > "Error from server: code=2200 [Invalid query] message=\"Request is too > big: length 268435580 exceeds maximum

Re: Send large blobs

Based on the information available at https://github.com/apache/cassandra/blob/trunk/doc/native_protocol_v4.spec#L208 /currently a frame is limited to 256MB in length/ and at https://github.com/apache/cassandra/blob/trunk/doc/native_protocol_v5.spec#L364 /currently an envelope body is

Re: Send large blobs

Thank you for your prompt reply! So, I have to split the blob into chunks by myself, or there is any fragmentation mechanism in Cassandra? > On 31 May 2022, at 4:44 PM, Dor Laor wrote: > > On Tue, May 31, 2022 at 4:40 PM Andria Trigeorgi > wrote: > Hi, > > I

Re: Send large blobs

You have to split it by yourself Best, Sergio On Tue, May 31, 2022, 3:56 PM Andria Trigeorgis wrote: > Thank you for your prompt reply! > So, I have to split the blob into chunks by myself, or there is any > fragmentation mechanism in Cassandra? > > > On 31 May 2022, at 4:44 PM, Dor Laor wrote:

Re: Send large blobs

However, if I were you I would avoid that... Maybe I will place a url to S3 or GFS in Cassandra Best, Sergio On Tue, May 31, 2022, 4:10 PM Sergio wrote: > You have to split it by yourself > Best, > Sergio > > On Tue, May 31, 2022, 3:56 PM Andria Trigeorgis > wrote: > >> Thank you for your pro

Re: Send large blobs

Thank you all! > On 31 May 2022, at 5:13 PM, Sergio wrote: > >  > However, if I were you I would avoid that... Maybe I will place a url to S3 > or GFS in Cassandra > > Best, > > Sergio > >> On Tue, May 31, 2022, 4:10 PM Sergio wrote: >> You have to split it by yourself >> Best, >> Sergi

RE: Fetch all data from Cassandra 3.4.4

A select with no where clause is not a good access pattern for Cassandra, regardless of driver version. It will not scale for large data sets or a large number of nodes. Ideally you want to select from a single partition for each query. So, depending on the size of the rows, one answer may be t