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