Re: [MonetDB-users] Copy Into problem

On Tue, Dec 30, 2008 at 03:19:42AM -0800, Alfred Nordman wrote:

Hi Niels,

the first chars do not appear in the csv!!!!!

Sorry they do, but they look different. Niels

Niels Nes wrote:

...

On Tue, Dec 30, 2008 at 01:50:32AM -0800, Alfred Nordman wrote:

...

Hi Fabian,

The error i get is: !SQLException:sql:value '?»¿1997-01-01 00:00:00' while parsing '?»¿1997-01-01 00:00:00|City Mall|1110|6165|33|8122' from line 0 field 0 not inserted, expecting type date !SQLException:importTable:failed to import table

It seems like some chars (?»¿) are added to the first row inserted to the table. The chars do not appear in the csv file (attached).

With less you can see the following first chars .

Niels

...

Alfred

Fabian Groffen wrote:

...

Hi Alfred,

On 29-12-2008 00:58:40 -0800, Alfred Nordman wrote:

...

I'm trying to use the copy into with csv file (utf-8 encoded) and I encounter some problem. The create statement is:

CREATE TABLE "sa3e7e9f4d666429ea2c5bb61a532f5b9" ("A" DATE ,"B" VARCHAR (22) ,"C" DECIMAL (12, 5) ,"D" DECIMAL (12, 5) ,"E" DECIMAL (12, 5) ,"F" DECIMAL (12, 5) )

The copy into statement is:

COPY INTO "sa3e7e9f4d666429ea2c5bb61a532f5b9" FROM

'T:\\Prism\\Applications\\Desktop\\PrismDesktop\\bin\\Debug\\LocalRepository\\ImportedCSV\\ImportedCSV0.csv'

...

...

USING DELIMITERS '|' NULL AS 'A56A9FC261A143a48F6019F602ABF409';

And csv is attached.

Do you have any error message? I suspect the DATETIME to be a problem, as your table specifies a DATE, but my knowledge on SQL's date/time/timezone stuff is a bit rusty.

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

...

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

-- View this message in context: http://www.nabble.com/Copy-Into-problem-tp21200441p21215000.html Sent from the monetdb-users mailing list archive at Nabble.com.

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

--

Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

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

-- View this message in context: http://www.nabble.com/Copy-Into-problem-tp21200441p21215876.html Sent from the monetdb-users mailing list archive at Nabble.com.

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

-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl