0

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?

Umaiki
  • 354
  • 2
  • 14
Ada
  • 1
  • 5
  • Who can help me? Urgency – Ada Apr 13 '18 at 14:01
  • Is you table named `123` or `usgs`? Do you get the same error if you change the second delimiter from `'|\n'` to `'\n'`? – Pakman May 30 '18 at 20:55
  • 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 Sep 26 '18 at 14:35

2 Answers2

0

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

redexp
  • 4,765
  • 7
  • 25
  • 37
0

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.

Nachiket Deo
  • 35
  • 6