[jira] [Commented] (CASSANDRA-8934) COPY command has inherent 128KB field size limit

["Tyler Hobbs (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-8934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14353453#comment-14353453 ] 

Tyler Hobbs commented on CASSANDRA-8934:
----------------------------------------

I think the best option is to create a cqlsh config option (just in the config file, not the command line) to specify a limit.  Let's target 2.0+.

Did you want to take this ticket?

> COPY command has inherent 128KB field size limit
> ------------------------------------------------
>
>                 Key: CASSANDRA-8934
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8934
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>            Reporter:  Brian Hess
>              Labels: cqlsh
>
> In using the COPY command as follows:
> {{cqlsh -e "COPY test.test1mb(pkey, ccol, data) FROM 'in/data1MB/data1MB_9.csv'"}}
> the following error is thrown:
> {{<stdin>:1:field larger than field limit (131072)}}
> The data file contains a field that is greater than 128KB (it's more like almost 1MB).
> A work-around (thanks to [~jjordan] and [~thobbs] is to modify the cqlsh script and add the line
> {{csv.field_size_limit(1000000000)}}
> anywhere after the line
> {{import csv}}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)