Re: [MonetDB-users] [Monetdb-developers] about import *.csv
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512
You must reply to the mailinglist, and not to me directly. In order to help you with your segmentation fault you also must provide what version you are using.
Op 12-07-10 06:57, kun ren schreef:
Thank you, when I am trying,something is wrong, when i use command," mclient -l sql -d demo" and then use command "create table t1(name char(100),number int);" to create a table; and then I create a csv file, the content of the file is: renkun,1 shaolong,2 laoluo,3 and then i use command as you said,"copy 3 records into t1 from 1.csv delimiters ',','\n';" but the server said:"Segmentation fault ",what wrong with me?thanks Best regards;
2010/7/12 Stefan de Konink <stefan@konink.de mailto:stefan@konink.de>
On Mon, 12 Jul 2010, kun ren wrote: Dear all, I want to import *.csv into MonetDB,what interface do i will use？ Just mclient, create your table. And use copy into so for example copy i<<numofrows>> records into <<justcreatedtable>> from 'filename' delimiters ',', '\n', null as ''; Stefan
Thank you,Stefan de Konink ,I have Solve my problems. Best regards!
在 2010年7月12日 下午12:59，Stefan de Konink stefan@konink.de写道：
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512
You must reply to the mailinglist, and not to me directly. In order to help you with your segmentation fault you also must provide what version you are using.
Op 12-07-10 06:57, kun ren schreef:
Thank you, when I am trying,something is wrong, when i use command," mclient -l sql -d demo" and then use command "create table t1(name char(100),number int);" to create a table; and then I create a csv file, the content of the file is: renkun,1 shaolong,2 laoluo,3 and then i use command as you said,"copy 3 records into t1 from 1.csv delimiters ',','\n';" but the server said:"Segmentation fault ",what wrong with me?thanks Best regards;
2010/7/12 Stefan de Konink <stefan@konink.de mailto:stefan@konink.de>
On Mon, 12 Jul 2010, kun ren wrote: Dear all, I want to import *.csv into MonetDB,what interface do i will use？ Just mclient, create your table. And use copy into so for example copy i<<numofrows>> records into <<justcreatedtable>> from 'filename' delimiters ',', '\n', null as ''; Stefan-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.15 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEAREKAAYFAkw6oSYACgkQYH1+F2Rqwn1OzwCglSIGOl+tKxMk+bbDPPaLUX+i plwAn0aeeJKs3TLiNk4cHPURovJqh8T7 =+Tr/ -----END PGP SIGNATURE-----
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512
Op 12-07-10 07:05, kun ren schreef:
Thank you,Stefan de Konink ,I have Solve my problems.
What did you do to get the Segmentation Fault?
Stefan
I use wrong command copy from,lack of ' ' of the filename, I replace it as '1.csv',and it is ok.Thanks
在 2010年7月12日 下午1:09，Stefan de Konink stefan@konink.de写道：
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512
Op 12-07-10 07:05, kun ren schreef:
Thank you,Stefan de Konink ,I have Solve my problems.
What did you do to get the Segmentation Fault?
Stefan
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.15 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEAREKAAYFAkw6o5kACgkQYH1+F2Rqwn2kxACggNrUhdlbaNJ5Jv4CqxjZmJxc PG8An2nTc6Z9C1NZ8VoRggvvYuYALja9 =da9g -----END PGP SIGNATURE-----
The statements do not cause problems on the latests release.
Tests> mclient copy_from_file.sql MAPI = monetdb@localhost:50000 QUERY = create table t1(name char(100),number int);
COPY 3 RECORDS INTO t1 FROM 2.csv delimiters ',','\n'; a,1 b,2 c,3
drop table t1; ERROR = !CREATE TABLE: name 't1' already in use !syntax error, unexpected INTNUM, expecting STRING or '(' or STDIN in: "copy 3 records into t1 from 2." !syntax error, unexpected IDENT in: "a"
Please try to reproduce the error and provide version information.
Stefan de Konink wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512
You must reply to the mailinglist, and not to me directly. In order to help you with your segmentation fault you also must provide what version you are using.
Op 12-07-10 06:57, kun ren schreef:
Thank you, when I am trying,something is wrong, when i use command," mclient -l sql -d demo" and then use command "create table t1(name char(100),number int);" to create a table; and then I create a csv file, the content of the file is: renkun,1 shaolong,2 laoluo,3 and then i use command as you said,"copy 3 records into t1 from 1.csv delimiters ',','\n';" but the server said:"Segmentation fault ",what wrong with me?thanks Best regards;
2010/7/12 Stefan de Konink <stefan@konink.de mailto:stefan@konink.de>
On Mon, 12 Jul 2010, kun ren wrote: Dear all, I want to import *.csv into MonetDB,what interface do i will use？ Just mclient, create your table. And use copy into so for example copy i<<numofrows>> records into <<justcreatedtable>> from 'filename' delimiters ',', '\n', null as ''; Stefan-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.15 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEAREKAAYFAkw6oSYACgkQYH1+F2Rqwn1OzwCglSIGOl+tKxMk+bbDPPaLUX+i plwAn0aeeJKs3TLiNk4cHPURovJqh8T7 =+Tr/ -----END PGP SIGNATURE-----
This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (3)
-
kun ren -
Martin Kersten -
Stefan de Konink