I have a MariaDB Columnstore database running on the cloud in Linux. I'm trying to export a CSV file from my Windows machine to the database. I created the file with DBeaver, setting the new line as
\n
. I execute the cpimport
command (provided by MariaDB) and I get the following error:
line 2: $'\r': command not found
I cannot figure out where's the problem, is it in the CSV file or in the cpimport
?
This is how I import in MariaDB:
sudo cpimport -s '|' -E '"' -C '\n' my_database dates dates.csv
Asked by ps0604
(51 rep)
Jul 27, 2021, 12:49 PM
Last activity: Jul 15, 2025, 10:05 PM
Last activity: Jul 15, 2025, 10:05 PM