Overflow of blob field buffer

Hi,

I'm trying to send a blob field to a Cassandra database via the Output Data connector but I have the following warning :

"BLOB: Overflow of blob field buffer length 4000 Input Record : 10395"

And when I try to read this field from my Database, the blob field is null. I cannot find what this warning mean and how I can extend this "blob field buffer", any idea?

I'm using Alteryx 10.6 connected to a Datastax Cassandra DB 4.7 (or cassandra 2.0 ) with the Simba driver.

Thanks for your help.

Cyprien

Settings

Error Message

Output

Connectors

Database Connection

Accepted answers

LindaT

Hi Cyprien,

The default Binary column length on the ODBC Driver is 4000. that is on the "Advanced Options" of your ODBC Drivers setup. All you need to do is increase that size to something more appropriate for your data. For our testing we have it set to 300000.

Thank you,

Linda

All comments

Aguisande

Hi Cyprien,

Have you tried to get a "local" version of the contents first, to see if the info being sent to Cassandra is correct?

Then try to send it directly to Cassandra?

LindaT

Hi Cyprien,

Thank you,

Linda

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703