Using this table:
insert one row:
Use COPY to dump the row to temp.csv:
Which creates this file:
Truncate the testtab table and then use copy from with NULL='' to insert the row:
It shows 1 rows inserted, but the table is empty:
The same error is returned even without the with NULL=''. Is it actually possible for copy from to insert an empty row into the primary key? The insert command shown above inserts the empty row for the primary key without any problems.
Is this related to https://issues.apache.org/jira/browse/CASSANDRA-7792?