Importing CSV to MonetDB

0
votes

I am new for using MonetDB. I have imported .csv file in it.

However there are always the problem :

sql>COPY INTO 123 FROM' C:\Program Files\MonetDB\112.csv' USING DELIMITERS '|', '|\n' LOCKED; COPY INTO: filename must have absolute path: C:\Program Files\MonetDB\112.csv

OR It display another question :

sql>COPY INTO usgs FROM 'C:\Program Files\MonetDB\112.csv' USING DELIMITERS '|', '|\n' LOCKED; Failed to import table '123', incomplete record at end of file

I do not konw how to solve it?

2
csvmonetdb
Who can help me? Urgency – Ada
Is you table named 123 or usgs? Do you get the same error if you change the second delimiter from '|\n' to '\n'? – Pakman
I found that sometimes the \ in windows is interpreted as an escape character by the monetdb parser. You might want to use a double \\ for every \ – Allen Wang

2 Answers

0
votes

Try using delimiters '|', '\n', ''. Here discussion of this problem

0
votes

I have faced the similar issue a while ago when I was working on case-study. I have to resolve it via Pentaho ETL tool which ships with MonetDB BulkLoader.

I'm not sure that's how you want the stuff to run but for me it worked and it was fast as well.

Please refer to the article - https://medium.com/dataengineering-and-algorithms/the-use-of-column-store-database-for-data-warehousing-fcf8d3e1941c

Coming back to your question did you try changing the slash to '/' in the path.