Maximum size of a single data value

We have been asked about the maximum capacity of a single value (cell) in Easy Data Transform. We investigated and the answer is 2^30=1,073,741,824 characters, assuming you have enough memory available. I think you need to ask yourself some serious questions if you get anywhere that!

We did a test and read in a .csv file the contained the text of Moby Dick (which is over a million characters) as a single value. It worked fine.

On a related note, the maximum number of rows or columns a dataset can have is 2^28=268,435,456. You are likely to run out of memory before you get anywhere near that.


Now imagine a file with 268,435,456 - 1row, each with 1,073,741,824 -1 character :exploding_head:

1 Like