Hi,

thanks for the quick answers :)

I corrected all the decimal values and tested again without success. Made the same test with Linux and everything went ok.

I must be doing something wrong when testing with Windows.

I will continue my tests with Linux instead.

Thanks for your precious help.

Best regards,

2013/6/12 Martin Kersten <martin@monetdb.org>

Hi

running a sample of your input on my Linux systems shows the cause:

mk@vienna::~> mclient -d spinque -s "COPY INTO FactInternetSales FROM STDIN USING DELIMITERS ',', '\n', '\"'" - <input
value '3578,27' from line 1 field 13 not inserted, expecting type real
failed to import table

We use decimal points.

On 6/12/13 8:07 PM, Raquel Ribeiro wrote:

Hi,

I am trying do bulk load like I saw here http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/LoadingBulkData
, but I am not having success when doing it.

I am trying to bulk load more than 60k registers using the following command:
> mclient -d adventurework -s "COPY INTO FactInternetSales FROM STDIN USING DELIMITERS ',', '\n', '\"'" - < C:Users\dir\text.txt

After running this command I do not receive any error message but I cannot see the data in the database either.
What am I missing here? Am I trying to this in the wrong way?

PS: I also tried with a smaller file but in the end I have the same result. I attached my partial data file in case of being necessary and the create of this table. And the system is Windows.

Thanks for your attention.
Best regards,

--
Raquel Ribeiro

_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list

--
Raquel Ribeiro