i'm trying to import data from csv files according to notepad++ encoded in utf-8-bom to tables in cassandra4.0 and i'm getting error:
Starting copy of airportdb.airport with columns [airport_id, iata, icao, name].
airport.cql:44:Failed to import 1 rows: ParseError - Failed to parse 1 : invalid literal for int() with base 10: '\ufeff1', given up without retries
My import code:
CREATE TABLE airplane (
airplane_id int PRIMARY KEY,
capacity int,
type_id int,
airline_id int
) ;
COPY airplane (airplane_id, capacity, type_id, airline_id)
FROM 'airplane.csv' WITH DELIMITER = ';';
and how it csv looks like CSVFile
cqlsh can't parse the BOM-encoded entries in your CSV file.
Save the file as just plain text then try again. Cheers!