Cassandra CQLSH TEXT field limit on COPY FROM CSV (field larger than field limit (131072))

Vercintegorix picture Vercintegorix · Jun 11, 2014 · Viewed 8.6k times · Source

When importing a record with a large field inside (longer than 124214 characters) I am getting the error

"field larger than field limit (131072)"

I saw form other posts how to solve this on Python but I don't know if it is possible on CQLSH.

Thanks

Answer

mikea picture mikea · Jun 11, 2014

Take a look at this answer:

_csv.Error: field larger than field limit (131072)

You will need to add this solution to the top of the cqlsh file. So after:

import csv
import getpass

csv.field_size_limit(sys.maxsize)