Hi,
I investigated further, and actually I cannot get any CSV file working with monetDB's COPY INTO on Windows.
Hannes filed a bug report today: https://www.monetdb.org/bugzilla/show_bug.cgi?id=3484
However, I tried other things since his/our attempts, e.g. removing the final end-of-line (EOL, still CRLF on Windows) or switching EOL to LF only for the temporary file (and changing the COPY INTO call's delimiters too, of course). Neither helped. Still the same error: Incomplete record at end of file. (Which I am not sure whether it literally means the end of the source textfile or simply the last line before breaking.)
Basically, the question is, is there a way to get this working on Windows in Jan14-SP1? Or could someone please verify it's worth downgrading to a previous because it definitely can do COPY INTO?
Thanks!
Laszlo
Perfect, I can verify it works for me as well! http://homepages.cwi.nl/~hannes/importer.py
Thanks a lot,
Laszlo
On Wed, May 21, 2014 at 5:18 PM, Hannes Mühleisen Hannes.Muehleisen@cwi.nlwrote:
On 05/21/2014 04:52 PM, László Sándor wrote:
I investigated further, and actually I cannot get any CSV file working with monetDB's COPY INTO on Windows.
Turns out (on Windows), the line terminator has to be specified as \n even if the file uses \r\n.
Best,
Hannes
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
However, now I got an error about the 'ascii' codec being unable to decode a byte, an ordinal was not in range(128). If I open my data in a text editor (showing human-legible characters), it says the encoding is Western (ISO Latin 1). Can I specify this for COPY INTO somehow?
Somewhat worrying, I don't see a relevant option in the documentation: https://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto
Thanks!
On Wed, May 21, 2014 at 5:28 PM, László Sándor sandorl@gmail.com wrote:
Perfect, I can verify it works for me as well! http://homepages.cwi.nl/~hannes/importer.py
Thanks a lot,
Laszlo
On Wed, May 21, 2014 at 5:18 PM, Hannes Mühleisen < Hannes.Muehleisen@cwi.nl> wrote:
On 05/21/2014 04:52 PM, László Sándor wrote:
I investigated further, and actually I cannot get any CSV file working with monetDB's COPY INTO on Windows.
Turns out (on Windows), the line terminator has to be specified as \n even if the file uses \r\n.
Best,
Hannes
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Hannes Mühleisen
-
László Sándor