[MonetDB-users] type mismatch on COPY command
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.
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 |
*OK, I found out what's wrong - the length of the varchar was shorter than
the string I was trying to insert.
The error is a little confusing...
*
On Mon, Nov 9, 2009 at 1:41 PM, Stefan Manegold
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
Hi,
I am trying to upload 500000 records using copy command and I am getting
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
On Mon, Nov 09, 2009 at 01:31:46PM -0500, Roman Sokolyuk wrote: the 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/http://www.cwi.nl/%7Emanegold/ | | 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
participants (2)
-
Roman Sokolyuk -
Stefan Manegold