copy into: Failed to import table Leftover data 'False' #6203
Last updated: 2017-03-03 10:24:21 +0100
Date: 2017-02-05 17:29:18 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2868.3 Safari/537.36
I have just upgraded to the default branch of the MonetDB repository and with a clean installation/dbfarm. I am importing tables to restore the functionality. The last table I want to copy into is a file of 11GB. Originally defined by:
create table m152 (ts timestamp, vehiclenumber integer, lon numeric(9,7), lat numeric(8, 6), sat integer);
When trying to import I end up with the error message below. Since there is no mention of what "Leftover data" is, and is ambiguous if there is a table called leftover data that leaves the end user clueless how to proceed.
copy into m152 from '/mnt/volatile/raw/radiolog-new/M152.csv' delimiters '\t', '\n';
I figured out that the table definition changed, and should be:
create table m152 (ts timestamp, vehiclenumber integer, lon numeric(9,7), lat numeric(8, 6), sat integer, open boolean);
I would suggest to change the error message to:
Failed to import table m152. More columns were found than defined in the table definition. The extra data found is 'False'.
MonetDB 5 server v11.26.0 (64-bit, 128-bit integers)
p.s. <3 importing 11GB :)
Date: 2017-02-13 08:29:13 +0100
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=891a9c0505d5
Date: 2017-02-13 08:29:30 +0100
improved the error message
Date: 2017-03-03 10:24:21 +0100
Dec2016-SP2 has been released, incorporating the fix.
The text was updated successfully, but these errors were encountered: