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
Solved! Go to Solution.
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?
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
Hi Linda,
Thanks a lot for your answer, it is now working fine with the Binary Column Length extended :)
Cyprien