[MonetDB-users] COPY command syntax
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*
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
Thanks!!! On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink <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 https://lists.sourceforge.net/lists/listinfo/monetdb-users
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 <romsok.tech@gmail.com>wrote:
Thanks!!!
On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink <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 https://lists.sourceforge.net/lists/listinfo/monetdb-users
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 <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 <romsok.tech@gmail.com> wrote:
Thanks!!!
On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink <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 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
thanks. Will try now On Thu, Oct 29, 2009 at 3:59 PM, Guillaume Theoret <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 <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 <romsok.tech@gmail.com> wrote:
Thanks!!!
On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink <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 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
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 <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 <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 <romsok.tech@gmail.com <mailto:romsok.tech@gmail.com>> > wrote: >> >> Thanks!!! >> >> On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink <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> >>> 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
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 <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 <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 <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 <romsok.tech@gmail.com <mailto:romsok.tech@gmail.com>> > wrote: >> >> Thanks!!! >> >> On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink <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> >>> 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
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 <sjoerd@acm.org <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 <smokinn@gmail.com <mailto:smokinn@gmail.com> > <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 > <romsok.tech@gmail.com <mailto:romsok.tech@gmail.com> <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 > <romsok.tech@gmail.com <mailto:romsok.tech@gmail.com> <mailto:romsok.tech@gmail.com <mailto:romsok.tech@gmail.com>>> > > wrote: > >> > >> Thanks!!! > >> > >> On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink > <stefan@konink.de <mailto:stefan@konink.de> <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 <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 <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 <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
Perfect. It all worked now. Thank you all for your input. On Fri, Oct 30, 2009 at 3:50 AM, Sjoerd Mullender <sjoerd@acm.org> 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 <sjoerd@acm.org <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 <smokinn@gmail.com <mailto:smokinn@gmail.com> > <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 > <romsok.tech@gmail.com <mailto:romsok.tech@gmail.com> <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 > <romsok.tech@gmail.com <mailto:romsok.tech@gmail.com> <mailto:romsok.tech@gmail.com <mailto:romsok.tech@gmail.com>>> > > wrote: > >> > >> Thanks!!! > >> > >> On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink > <stefan@konink.de <mailto:stefan@konink.de> <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 <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 <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 <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
participants (4)
-
Guillaume Theoret -
Roman Sokolyuk -
Sjoerd Mullender -
Stefan de Konink