Does someone knows the right syntaxis for Cassandra COPY FROM command with delimiter and maxinserterrors?
I'm trying to run it as follow:
copy keyspace.table (field1,field2,field3) FROM './iinfo_current_file3.dat' WITH DELIMITER = '|' AND MAXINSERTERRORS = '10';
I'm getting the following error:
<stdin>:2:Unrecognized COPY FROM options: maxinserterrors
I'm using:
cqlsh 5.0.1 | Cassandra 2.1.11.969 | DSE 4.8.3 | CQL spec 3.2.1 | Native protocol v3
Your syntax is correct, but your version of Cassandra (cqlsh) is too old. MAXINSERTERRORS is a new option in the 2.1 branch as of 2.1.13: New options and better performance in cqlsh COPY.
To verify, try this:
$ grep -i MAXINSERTERRORS `which cqlsh`
If it is valid, you should see something like:
$ grep -i MAXINSERTERRORS `which cqlsh`
'SKIPROWS', 'SKIPCOLS', 'MAXPARSEERRORS', 'MAXINSERTERRORS', 'ERRFILE', 'TTL']
MAXINSERTERRORS=-1 - the maximum global number of insert errors, -1 means no maximum
And in the newer versions, you might have to look in cqlsh.py:
$ grep -i MAXINSERTERRORS `which cqlsh.py`
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments