On Wed, Nov 28, 2007 at 01:45:44PM -0700, m h wrote:
Whoops forgot one bit of the error....
Is there a sample tbl file somewhere? When I run the command I get IN the sources sql/src/benchmark/tpch/SF-0.01/ the following:
copy 5 records into vendor_dim from '/tmp/vendor.csv' using delimiters '|', '|\n';
!SQLException:sql:decimal wrong format ....contents of file like the following... !2456|'2456'|'FOO BAR CAFE'||'875 CENTER STREET RM'|'NY'|'NY'|' 96813'||||2456|2004-08-18||2004-08-19 ^
Which of these is supposed to be a decimal? (quotes are only needed in case the strings aren't safe, ie when they contain the seperator. I you use the two given seperators (field and record) then at the end you need '|\n' or change the seperator into '\n'. niels
!SQLException:importTable:failed to import table
------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ 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