Re: [MonetDB-users] COPY command syntax

29 Oct 2009

      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