[MonetDB-users] COPY command syntax

newer
[MonetDB-users] Convert date field...

older
[MonetDB-users] Announcement: New...

Roman Sokolyuk

28 Oct 2009 28 Oct '09

10:15 p.m.

Hi, Could someone please point out to me what is wrong with the way I am using the COPY utility? Here is what I typed: COPY 2 RECORDS INTO my_table FROM (C:\MyDir\MyFile.txt) USING DELIMITERS field_separator ',' record_separator ','; I got this error: *!syntax error, unexpected IDENT, expecting STRING in: "copy 2 records !into my_table from (c" 0 tuples*

Attachments:

attachment.html (text/html — 2.9 KB)

Show replies by date

Stefan de Konink

28 Oct 28 Oct

10:23 p.m.

On Wed, 28 Oct 2009, Roman Sokolyuk wrote:

...

Could someone please point out to me what is wrong with the way I am using the COPY utility?

I can give you a working example: http://mirror.openstreetmap.nl/rivm/stations.sql Stefan

Roman Sokolyuk

11:19 p.m.

Thanks!!! On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink wrote:

...

On Wed, 28 Oct 2009, Roman Sokolyuk wrote:

...
Could someone please point out to me what is wrong with the way I am using the COPY utility?

I can give you a working example:

http://mirror.openstreetmap.nl/rivm/stations.sql

Stefan

------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

Roman Sokolyuk

29 Oct 29 Oct

7:36 p.m.

I tried running the command following your example and I think I am still doing something wrong: * sql>COPY 110301 RECORDS INTO my_table FROM ('C:\MyFile.csv') DELIMITERS ',', '\n', ''''; !Cannot pass number of records in Binary COPY INTO in: "copy 110301 records into my_table from ('C:\MyFile.csv')" !syntax error, unexpected DELIMITERS in: "delimiters"* On Wed, Oct 28, 2009 at 7:19 PM, Roman Sokolyuk wrote:

...

Thanks!!!

On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink wrote:

...
On Wed, 28 Oct 2009, Roman Sokolyuk wrote:

...
Could someone please point out to me what is wrong with the way I am using the COPY utility?

I can give you a working example:

http://mirror.openstreetmap.nl/rivm/stations.sql

Stefan

------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

Guillaume Theoret

7:59 p.m.

I had trouble with the delimiters as well. I ended up finding a message on the mailing list a while back that had the right syntax. Here's my command that works: COPY 1000000 RECORDS INTO test.aggregated_detail_data_2009 FROM '/home/monetdb/aggregated_detail_data_2009_1.csv' using delimiters ',','\n'; On Thu, Oct 29, 2009 at 3:36 PM, Roman Sokolyuk wrote:

...

I tried running the command following your example and I think I am still doing something wrong:

sql>COPY 110301 RECORDS INTO my_table FROM ('C:\MyFile.csv') DELIMITERS ',', '\n', ''''; !Cannot pass number of records in Binary COPY INTO in: "copy 110301 records into my_table from ('C:\MyFile.csv')" !syntax error, unexpected DELIMITERS in: "delimiters"

On Wed, Oct 28, 2009 at 7:19 PM, Roman Sokolyuk wrote:

...
Thanks!!!

On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink wrote:

...
On Wed, 28 Oct 2009, Roman Sokolyuk wrote:

...
Could someone please point out to me what is wrong with the way I am using the COPY utility?

I can give you a working example:

http://mirror.openstreetmap.nl/rivm/stations.sql

Stefan

------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

Roman Sokolyuk

8:04 p.m.

thanks. Will try now On Thu, Oct 29, 2009 at 3:59 PM, Guillaume Theoret wrote:

...

I had trouble with the delimiters as well. I ended up finding a message on the mailing list a while back that had the right syntax. Here's my command that works:

COPY 1000000 RECORDS INTO test.aggregated_detail_data_2009 FROM '/home/monetdb/aggregated_detail_data_2009_1.csv' using delimiters ',','\n';

On Thu, Oct 29, 2009 at 3:36 PM, Roman Sokolyuk wrote:

...
I tried running the command following your example and I think I am still doing something wrong:

sql>COPY 110301 RECORDS INTO my_table FROM ('C:\MyFile.csv') DELIMITERS ',', '\n', ''''; !Cannot pass number of records in Binary COPY INTO in: "copy 110301 records into my_table from ('C:\MyFile.csv')" !syntax error, unexpected DELIMITERS in: "delimiters"

On Wed, Oct 28, 2009 at 7:19 PM, Roman Sokolyuk wrote:

...
Thanks!!!

On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink wrote:

...
On Wed, 28 Oct 2009, Roman Sokolyuk wrote:

...
Could someone please point out to me what is wrong with the way I am using the COPY utility?

I can give you a working example:

http://mirror.openstreetmap.nl/rivm/stations.sql

Stefan

...
...
...
Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------

...
Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

Sjoerd Mullender

9:04 p.m.

You may need to double the \ characters in your path or use / instead. On 2009-10-29 21:04, Roman Sokolyuk wrote:

...

thanks. Will try now

On Thu, Oct 29, 2009 at 3:59 PM, Guillaume Theoret mailto:smokinn@gmail.com> wrote:

I had trouble with the delimiters as well. I ended up finding a message on the mailing list a while back that had the right syntax. Here's my command that works:

COPY 1000000 RECORDS INTO test.aggregated_detail_data_2009 FROM '/home/monetdb/aggregated_detail_data_2009_1.csv' using delimiters ',','\n';

On Thu, Oct 29, 2009 at 3:36 PM, Roman Sokolyuk mailto:romsok.tech@gmail.com> wrote: > I tried running the command following your example and I think I am still > doing something wrong: > > > sql>COPY 110301 RECORDS INTO my_table FROM ('C:\MyFile.csv') DELIMITERS ',', > '\n', ''''; > !Cannot pass number of records in Binary COPY INTO in: "copy 110301 records > into my_table from ('C:\MyFile.csv')" > !syntax error, unexpected DELIMITERS in: "delimiters" > > On Wed, Oct 28, 2009 at 7:19 PM, Roman Sokolyuk mailto:romsok.tech@gmail.com> > wrote: >> >> Thanks!!! >> >> On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink mailto:stefan@konink.de> >> wrote: >>> >>> On Wed, 28 Oct 2009, Roman Sokolyuk wrote: >>> >>> > Could someone please point out to me what is wrong with the way I am >>> > using >>> > the COPY utility? >>> >>> I can give you a working example: >>> >>> http://mirror.openstreetmap.nl/rivm/stations.sql >>> >>> >>> Stefan >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA >>> is the only developer event you need to attend this year. Jumpstart your >>> developing skills, take BlackBerry mobile applications to market and stay >>> ahead of the curve. Join us from November 9 - 12, 2009. Register now! >>> http://p.sf.net/sfu/devconference >>> _______________________________________________ >>> MonetDB-users mailing list >>> MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/monetdb-users >> > > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > MonetDB-users mailing list > MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users > >

------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference

_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Sjoerd Mullender

Roman Sokolyuk

9:56 p.m.

Actually, this almost worked: *sql>COPY 100 RECORDS INTO my_table FROM 'C:\MyFile.csv' USING DELIMITERS ',','\n';* Except I got the following error: *!SQLException:sql:value '2002-01-19 01:23:00' while parsing '2002-01-19 01:23:00,397,1527' from line 0 field 8 not inserted, expecting type date !SQLException:importTable:failed to import table* I thought I specified the date format exactly as it should feed into Monet.... any clue what I am doing wrong? On Thu, Oct 29, 2009 at 5:04 PM, Sjoerd Mullender wrote:

...

You may need to double the \ characters in your path or use / instead.

On 2009-10-29 21:04, Roman Sokolyuk wrote:

...
thanks. Will try now

On Thu, Oct 29, 2009 at 3:59 PM, Guillaume Theoret mailto:smokinn@gmail.com> wrote:

I had trouble with the delimiters as well. I ended up finding a message on the mailing list a while back that had the right syntax. Here's my command that works:

COPY 1000000 RECORDS INTO test.aggregated_detail_data_2009 FROM '/home/monetdb/aggregated_detail_data_2009_1.csv' using delimiters ',','\n';

On Thu, Oct 29, 2009 at 3:36 PM, Roman Sokolyuk mailto:romsok.tech@gmail.com> wrote: > I tried running the command following your example and I think I am still > doing something wrong: > > > sql>COPY 110301 RECORDS INTO my_table FROM ('C:\MyFile.csv') DELIMITERS ',', > '\n', ''''; > !Cannot pass number of records in Binary COPY INTO in: "copy 110301 records > into my_table from ('C:\MyFile.csv')" > !syntax error, unexpected DELIMITERS in: "delimiters" > > On Wed, Oct 28, 2009 at 7:19 PM, Roman Sokolyuk mailto:romsok.tech@gmail.com> > wrote: >> >> Thanks!!! >> >> On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink mailto:stefan@konink.de> >> wrote: >>> >>> On Wed, 28 Oct 2009, Roman Sokolyuk wrote: >>> >>> > Could someone please point out to me what is wrong with the way I am >>> > using >>> > the COPY utility? >>> >>> I can give you a working example: >>> >>> http://mirror.openstreetmap.nl/rivm/stations.sql >>> >>> >>> Stefan >>> >>> >>> >>>

------------------------------------------------------------------------------

...
>>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA >>> is the only developer event you need to attend this year. Jumpstart your >>> developing skills, take BlackBerry mobile applications to market and stay >>> ahead of the curve. Join us from November 9 - 12, 2009. Register now! >>> http://p.sf.net/sfu/devconference >>> _______________________________________________ >>> MonetDB-users mailing list >>> MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/monetdb-users >> > > >

------------------------------------------------------------------------------

...
> Come build with us! The BlackBerry(R) Developer Conference in SF,

CA

...
> is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register

now!

...
> http://p.sf.net/sfu/devconference > _______________________________________________ > MonetDB-users mailing list > MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users > >

------------------------------------------------------------------------------

...
Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart

your

...
developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------

...
Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference

_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Sjoerd Mullender

------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

Sjoerd Mullender

30 Oct 30 Oct

7:50 a.m.

On 2009-10-29 22:56, Roman Sokolyuk wrote:

...

Actually, this almost worked:

*sql>COPY 100 RECORDS INTO my_table FROM 'C:\MyFile.csv' USING DELIMITERS ',','\n';*

Except I got the following error:

*!SQLException:sql:value '2002-01-19 01:23:00' while parsing '2002-01-19 01:23:00,397,1527' from line 0 field 8 not inserted, expecting type date !SQLException:importTable:failed to import table*

I thought I specified the date format exactly as it should feed into Monet.... any clue what I am doing wrong?

The problem is, you're attempting to insert a timestamp into a date field. A date is just that, the date (e.g. 2002-01-19), whereas a timestamp includes both a date and a time (in the format you used).

...

On Thu, Oct 29, 2009 at 5:04 PM, Sjoerd Mullender mailto:sjoerd@acm.org> wrote:

You may need to double the \ characters in your path or use / instead.

On 2009-10-29 21:04, Roman Sokolyuk wrote: > thanks. Will try now > > On Thu, Oct 29, 2009 at 3:59 PM, Guillaume Theoret mailto:smokinn@gmail.com > mailto:smokinn@gmail.com>> wrote: > > I had trouble with the delimiters as well. I ended up finding a > message on the mailing list a while back that had the right syntax. > Here's my command that works: > > COPY 1000000 RECORDS INTO test.aggregated_detail_data_2009 FROM > '/home/monetdb/aggregated_detail_data_2009_1.csv' using delimiters > ',','\n'; > > On Thu, Oct 29, 2009 at 3:36 PM, Roman Sokolyuk > mailto:romsok.tech@gmail.com mailto:romsok.tech@gmail.com>> wrote: > > I tried running the command following your example and I think I > am still > > doing something wrong: > > > > > > sql>COPY 110301 RECORDS INTO my_table FROM ('C:\MyFile.csv') > DELIMITERS ',', > > '\n', ''''; > > !Cannot pass number of records in Binary COPY INTO in: "copy > 110301 records > > into my_table from ('C:\MyFile.csv')" > > !syntax error, unexpected DELIMITERS in: "delimiters" > > > > On Wed, Oct 28, 2009 at 7:19 PM, Roman Sokolyuk > mailto:romsok.tech@gmail.com mailto:romsok.tech@gmail.com>> > > wrote: > >> > >> Thanks!!! > >> > >> On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink > mailto:stefan@konink.de mailto:stefan@konink.de>> > >> wrote: > >>> > >>> On Wed, 28 Oct 2009, Roman Sokolyuk wrote: > >>> > >>> > Could someone please point out to me what is wrong with the > way I am > >>> > using > >>> > the COPY utility? > >>> > >>> I can give you a working example: > >>> > >>> http://mirror.openstreetmap.nl/rivm/stations.sql > >>> > >>> > >>> Stefan > >>> > >>> > >>> > >>> > ------------------------------------------------------------------------------ > >>> Come build with us! The BlackBerry(R) Developer Conference in > SF, CA > >>> is the only developer event you need to attend this year. > Jumpstart your > >>> developing skills, take BlackBerry mobile applications to > market and stay > >>> ahead of the curve. Join us from November 9 - 12, 2009. > Register now! > >>> http://p.sf.net/sfu/devconference > >>> _______________________________________________ > >>> MonetDB-users mailing list > >>> MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net > mailto:MonetDB-users@lists.sourceforge.net> > >>> https://lists.sourceforge.net/lists/listinfo/monetdb-users > >> > > > > > > > ------------------------------------------------------------------------------ > > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > > is the only developer event you need to attend this year. > Jumpstart your > > developing skills, take BlackBerry mobile applications to market > and stay > > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > > http://p.sf.net/sfu/devconference > > _______________________________________________ > > MonetDB-users mailing list > > MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net > mailto:MonetDB-users@lists.sourceforge.net> > > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > > > > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and > stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > MonetDB-users mailing list > MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net > mailto:MonetDB-users@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > > > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > > > > _______________________________________________ > MonetDB-users mailing list > MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Sjoerd Mullender

------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference

_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Sjoerd Mullender

Roman Sokolyuk

2:45 p.m.

Perfect. It all worked now. Thank you all for your input. On Fri, Oct 30, 2009 at 3:50 AM, Sjoerd Mullender wrote:

...

On 2009-10-29 22:56, Roman Sokolyuk wrote:

...
Actually, this almost worked:

*sql>COPY 100 RECORDS INTO my_table FROM 'C:\MyFile.csv' USING DELIMITERS ',','\n';*

Except I got the following error:

*!SQLException:sql:value '2002-01-19 01:23:00' while parsing '2002-01-19 01:23:00,397,1527' from line 0 field 8 not inserted, expecting type date !SQLException:importTable:failed to import table*

I thought I specified the date format exactly as it should feed into Monet.... any clue what I am doing wrong?

The problem is, you're attempting to insert a timestamp into a date field. A date is just that, the date (e.g. 2002-01-19), whereas a timestamp includes both a date and a time (in the format you used).

...
On Thu, Oct 29, 2009 at 5:04 PM, Sjoerd Mullender mailto:sjoerd@acm.org> wrote:

You may need to double the \ characters in your path or use / instead.

On 2009-10-29 21:04, Roman Sokolyuk wrote: > thanks. Will try now > > On Thu, Oct 29, 2009 at 3:59 PM, Guillaume Theoret mailto:smokinn@gmail.com > mailto:smokinn@gmail.com>> wrote: > > I had trouble with the delimiters as well. I ended up finding a > message on the mailing list a while back that had the right syntax. > Here's my command that works: > > COPY 1000000 RECORDS INTO test.aggregated_detail_data_2009 FROM > '/home/monetdb/aggregated_detail_data_2009_1.csv' using delimiters > ',','\n'; > > On Thu, Oct 29, 2009 at 3:36 PM, Roman Sokolyuk > mailto:romsok.tech@gmail.com mailto:romsok.tech@gmail.com>> wrote: > > I tried running the command following your example and I think I > am still > > doing something wrong: > > > > > > sql>COPY 110301 RECORDS INTO my_table FROM ('C:\MyFile.csv') > DELIMITERS ',', > > '\n', ''''; > > !Cannot pass number of records in Binary COPY INTO in: "copy > 110301 records > > into my_table from ('C:\MyFile.csv')" > > !syntax error, unexpected DELIMITERS in: "delimiters" > > > > On Wed, Oct 28, 2009 at 7:19 PM, Roman Sokolyuk > mailto:romsok.tech@gmail.com mailto:romsok.tech@gmail.com>> > > wrote: > >> > >> Thanks!!! > >> > >> On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink > mailto:stefan@konink.de mailto:stefan@konink.de>> > >> wrote: > >>> > >>> On Wed, 28 Oct 2009, Roman Sokolyuk wrote: > >>> > >>> > Could someone please point out to me what is wrong with the > way I am > >>> > using > >>> > the COPY utility? > >>> > >>> I can give you a working example: > >>> > >>> http://mirror.openstreetmap.nl/rivm/stations.sql > >>> > >>> > >>> Stefan > >>> > >>> > >>> > >>> >

------------------------------------------------------------------------------

...
> >>> Come build with us! The BlackBerry(R) Developer Conference in > SF, CA > >>> is the only developer event you need to attend this year. > Jumpstart your > >>> developing skills, take BlackBerry mobile applications to > market and stay > >>> ahead of the curve. Join us from November 9 - 12, 2009. > Register now! > >>> http://p.sf.net/sfu/devconference > >>> _______________________________________________ > >>> MonetDB-users mailing list > >>> MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net > mailto:MonetDB-users@lists.sourceforge.net> > >>> https://lists.sourceforge.net/lists/listinfo/monetdb-users > >> > > > > > > >

------------------------------------------------------------------------------

...
> > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > > is the only developer event you need to attend this year. > Jumpstart your > > developing skills, take BlackBerry mobile applications to market > and stay > > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > > http://p.sf.net/sfu/devconference > > _______________________________________________ > > MonetDB-users mailing list > > MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net > mailto:MonetDB-users@lists.sourceforge.net> > > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > > > > >

------------------------------------------------------------------------------

...
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and > stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > MonetDB-users mailing list > MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net > mailto:MonetDB-users@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > > > >

------------------------------------------------------------------------------

...
> Come build with us! The BlackBerry(R) Developer Conference in SF,

CA

...
> is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register

now!

...
> http://p.sf.net/sfu/devconference > > > > _______________________________________________ > MonetDB-users mailing list > MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Sjoerd Mullender

------------------------------------------------------------------------------

...
Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart

your

...
developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------

...
Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference

_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Sjoerd Mullender

------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

5609

Age (days ago)

5611

Last active (days ago)

List overview

Download

9 comments

4 participants

participants (4)

Guillaume Theoret
Roman Sokolyuk
Sjoerd Mullender
Stefan de Konink