Import data - MonetDB
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
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', '\"'" -
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
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
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', '\"'" -
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/LoadingBulkDatahttp://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-listhttp://mail.monetdb.org/mailman/listinfo/users-list
______________________________**_________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/**mailman/listinfo/users-listhttp://mail.monetdb.org/mailman/listinfo/users-list
-- Raquel Ribeiro
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
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', '\"'" -
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/LoadingBulkDatahttp://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-listhttp://mail.monetdb.org/mailman/listinfo/users-list
______________________________**_________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/**mailman/listinfo/users-listhttp://mail.monetdb.org/mailman/listinfo/users-list
-- Raquel Ribeiro
mclient -d FirstDB -h colnote24 -s "COPY INTO
bisim.nationalitaet_staat_privat FROM STDIN " - < <filename>
worked for me
2013/6/12 Raquel Ribeiro
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
participants (3)
-
hans kristian langva -
Martin Kersten -
Raquel Ribeiro