Roman,
to answer this question we'd need to know
- which version of MonetDB you are using (cf.,e.g., `mserver5 --version`)?
- how exactly does your create table statement look like?
- how exactly does your copy into statement look like?
- how exactly do lines 250106 - 250110 of your data file look like?
Thanks.
Stefan
> ------------------------------------------------------------------------------
On Mon, Nov 09, 2009 at 01:31:46PM -0500, Roman Sokolyuk wrote:
> Hi,
>
> I am trying to upload 500000 records using copy command and I am getting the
> following error:
>
> !SQLException:sql:value 'somestring' while parsing
> 'somestring,1,,,2009-05-11 00:00:00,0,,' from line 250108 field 3 not
> inserted, expecting type str
> !SQLException:importTable:failed to import table
>
>
> the type of the field is varchar(100). Why wouldn't it insert something like
> 'somestring'. Also, each row has another "string" column - "name" and it
> didn't complain about the names at all.
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users
--
| Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl |
| CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ |
| 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 |
| The Netherlands | Fax : +31 (20) 592-4312 |
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users